Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts
I have this expression in the script:
if([Reports]<0, [Reports]*(-1), [Reports]) as [Reports]
All of them have a numeric value. I need to change negative values, e.g. -130 into positive value, here 130.
The above expression is not working it is ignoring the *(-1).
Thank you for any help!
What about Fabs(Report) AS Report?
In addition to using Fabs() as suggested already, you'll want to confirm that Reports is being read as a numeric field. If it isn't, you'll likely need to num#() it.