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
Colin Sum(fabs(...
gives error
I updated the expression to
sum({<ACNT_FLEX_02={'Balance Sheet'}>} fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1) )
Hi Tresesco,
yours works fine. total is correct but shows incorrect value why?
Yes, that would change the value, if you want the absolute value of the sum, try like:
Sum(Aggr(Fabs(sum({<ACNT_FLEX_02={'Balance Sheet'}>} TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)), Dimension1, dimension2...))
I just notice the minus sign between the two fields, Adding spaces makes the expressions easier to read,
Try this
fabs(
sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1)
-
sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_CR_LC_1)
)
or
fabs( sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_DR_LC_1))
-
fabs( sum({<ACNT_FLEX_02={'Balance Sheet'}>}TBAL_MTD_CR_LC_1))
Incorrect subtotal colin
Can you post some example data and the subtotal you are expecting to see?
Did you check the 2nd expression i suggested above?
this one
Sum(Aggr(Fabs(sum({<ACNT_FLEX_02={'Balance Sheet'}>} TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)), Dimension1, dimension2...))
i replaced two dimesions in my chart above expression but incorrect value
plz some one check my sample app