Fabs function giving wrong total

[arulsettu]

hi i am trying to show negative values to positive

so did like this

=fabs(sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))

but my sub total is wrong any one tell me why?

Thanks

[arulsettu]

any idea?

[tresB]

Check your first expression column, i guess its sub total is correct.

[tresB · Accepted solution]

Put this expression and try:

=Sum(Aggr(fabs(sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)),ACNT_FLEX_01,ACNT_FLEX_03))

[arulsettu]

Thank you all