0

Sum Formula

Hello Team,

Screen Shot 2018-10-23 at 3.09.17 PM

 

im trying to figure out how to make this chart add up all the linetotal in groups based on what schedule b number it has. For example, on the formula, it should appear for the ones with the code 1103.11.0020, it should all be 14458.56 since it adds them up. Is there any way to do this? 

Thanks

2 replies

null
    • Mconneen
    • 6 yrs ago
    • Reported - view

    How about if you group by Schedule B and Sum the Export Value column?   Why a field formula.?

    Sum

    If you want to see the sum of the schedule on each of the same schedule .. 

    SumBySchedule

    Here is the formula.. 

    let t := this;
    sum((select Goods)['Schedule B' = t.'Schedule B'].'Export Value')

    • Agus
    • 6 yrs ago
    • Reported - view

    It worked great! Thank you :)

Login to reply

Content aside

  • 6 yrs agoLast active
  • 2Replies
  • 2351Views