Covert to negatvie values

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a bar chart with below expression

if( RowNo()= 1, column(1), column(1) - above(column(1)) )

The bar chart contains some negative and some positive values. please help me to convert all the values as negative.

By using fabs function we can convert to all as positive values. Is there any way to convert all values as negative.

fabs(if( RowNo()= 1, column(1), column(1) - above(column(1)) ))

Thanks in advance

[balabhaskarqlik]

May be this:

But parenthesis around the entire expression and put a - in front of it. If your expression starts with an = character then put that outside the parentheses, i.e. = -( ...Expression ...)