help with negitive number

[jobillborf]

I have a field UNITCOST, which has both positive and negative numbers.

Can a formula be written that will convert the negative number to a positive, and if the number is positive leave it alone.

 

[Turkbear]

Hi,
Try

If {UNITCOST} < 0
 then 
   {UNITCOST} * -1
 else
   {UNITCOST)

 

[bdreed35]

Why not just use the Abs function (returns the Absolute value)?

Abs({UNITCOST})

OR

if it just for display purposes, you can format the field to display it without the negative sign.

Right CLick on the field and choose Format Field
Choose the Number tab and click the Customize tab
In the drop down list next to negatives, choose "None"


~Brian

 

[Ngolem]

Abs({UNITCOST}) Is the way to go


Jim Broadbent