make dimension value numeric

[TomBond77]

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!

[steeefan]

What about Fabs(Report) AS Report?

[Or]

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.