7 Replies Latest reply on Apr 25, 2018 8:03 PM by donli.lv

    Showing sum of abs % in grand total for calculated field

    donli.lv

      hey guys, i have a question of achieving below calculation, i tried multiple ways, but cannot get what i expected.

       

      the % is calculated by ABS((sum([Sch])/(total(sum([Sch]))/4)/4)-(sum([Req])/(total(sum([Req]))/4)/4)), it's basically the value for each block divided by column total, and comparing the difference between req and sch.  sometimes req is higher, sometimes sch is higher.  what i am going to achieve is something like a SUM in excel for the % column, of the absolute values of %.  but even if i added ABS in the calculated fields, it returns 0% rather than 3.38% as you can easily sum five % numbers together.  not sure what's wrong here.