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
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))
where do you want the fabs?
fabs(sum....)
or
sum( ....fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
?
HI Arul,
it should be =sum(fabs({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
Fabs and sum are the wrong way round!
HTH Andy
Try like:
=sum({<ACNT_FLEX_02={'Balance Sheet'}>} Fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
Hiii..
Try like this
=sum(fabs({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
I hope it will work
Thanks
I would try =sum(fabs({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
it showing error
=sum(fabs({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
it showing correct total. but the value changed
Your expression is calculating the sum of the column and then using fabs() to show the absolute value after summing the records.
=fabs(sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))
If you want to calculate the absolute value of each record before summing the result, then you need to include
the fabs() function inside the sum.
=sum({<ACNT_FLEX_02={'Balance Sheet'}>} fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1) )
Fabs() is not an aggregation function, hence it shows error with set analysis expression in it. Try the way I showed above.