Remove negative value for query

[aud1ishere]

I made formula in a query field for one of my tables (i.e. Expr1: [Profit]/[SupplierPrice]) and the calculation comes out correct but it shows as a negative percentage value. How do I get rid of the negative sign so it shows as a positive percentage value?

 

[alansidman]

In your expression multiply what you currently have by -1

Alan

 

[SydneyGeek]

Is one of the values negative? ie, you make a loss and not a profit?
If so, you would surely need to keep the negative sign. Otherwise, you can just use the Abs function to always get a positive value:
Abs([Profit]/[SupplierPrice])

Denis