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

[maxgro]

where do you want the fabs?

fabs(sum....)

or

sum( ....fabs(TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1))

?

[awhitfield]

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

[tresesco]

Try like:

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

[prajapatiamar38]

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

[#6]

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

[arulsettu]

it showing error

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

[arulsettu]

it showing correct total. but the value changed

[Colin-Albert]

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

[tresesco]

Fabs() is not an aggregation function, hence it shows error with set analysis expression in it. Try the way I showed above.