Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I know this would convert negative to positive
Fabs(Num(ArrearsAmount,'-000000')) as ArrearsTest,
Is there a way to convert from Positive to negative
I am trying to show example
09/2016 arrears was £10 i want this to show -£10
so my barchart can go below 0
Thanks
Multiplying with -1 should do it, right?
-1 * YourField
Or
-1 * YourExpression
Try
-1*your-expression as stalwar1 suggested
Worked
Thanks alot Sunny!