Negative Values

[ivandrago]

Hi,

I have the attached document, I am doing the percentage difference between rrp and cost, I have a issue where there are two negative fields and this will show this as a positive, has anyone have any suggestions to show this as a negative?

Thanks

[maneshkhottcpl]

Hi,

Please use the below expression

=

if([Total Cost]<0 and [Total RRP]<0,-1,1) * ([Total Cost]/[Total RRP])

refer the attached document.

[maneshkhottcpl · Accepted solution]

HI Please refer the attached document.