Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
any idea?
Check your first expression column, i guess its sub total is correct.
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))
Thank you all