Make negative zero as positive zero in pivot table

[#1]

Greetings

Can someone help me to convert the negative zero value as positive in pivot table. I would like to highlight the cell value which is less than 0.

Please assist.

Thanks

[sunny_talwar · Accepted solution]

May be something like this:

fabs(YourExpression4Difference)

or

If(YourExpression4Difference >= -1 and YourExpression4Difference <= 0, 0, YourExpression4Difference)

[marcus_sommer]

You need to use rounding-functions like round(YourExpressionForColumn1) - round(YourExpressionForColumn2), see also: Rounding Errors

- Marcus

[Chanty4u]

=dual(fabs(sum(urexp))

or chk below

Re: Negative values in chart

[#5]

Thanks Sunny!!

It did work.