Error in Expression

[upaliwije]

if((Sum(ACTUAL)/$(=$(=vActual))*100)<0,Sum(ACTUAL)/$(=$(=vActual))*100)*-1,Sum(ACTUAL)/$(=$(=vActual))*100

The above expression in my Pivot Table  does not work. Will someone have a look at this and correct me please

[simondachstr]

Can you disclose the content of vActual variable.. And when you say it doesn't work - is the expression not OK in the expression editor or do you get null as a result where you were expecting values?

[upaliwije]

sum({$<DESCRIPTION={'GROSS_PREMIUM'}>}ACTUAL)

Expression is ok in expression editor    Expected Value is shown as -

[Anonymous · Accepted solution]

Try a simplified experssion:

=fabs((Sum(ACTUAL)/$(=$(=vActual))*100))

Marc.

[upaliwije]

Thanks All