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]

Colin Sum(fabs(...

gives error

[Colin-Albert]

I updated the expression to
sum({<ACNT_FLEX_02={'Balance Sheet'}>} fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1) )

[arulsettu]

Hi Tresesco,

                yours works fine. total is correct but shows incorrect value why?

[tresesco]

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...))

[Colin-Albert]

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))

[arulsettu]

Incorrect subtotal colin

[Colin-Albert]

Can you post some example data and the subtotal you are expecting to see?

[tresesco]

Did you check the 2nd expression i suggested above?

[arulsettu]

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

[arulsettu]

plz some one check my sample app