Negative Number

[Bazb1]

I am dealing with insurance taxes, some of which will be allowed(deducted from the premium) and others will be charged (added to the premium).

I have a field which will specified "Charge" or "Allow". I want the result (the value of the tax as a percentage of the premium) to be negative if "Allow" selected and positive if "Charge" selected. How do I make the result field show the negative?

[jamesducker]

abs (chargeValue ) * if ( chargeOrAllow = "Allow" ; -1 ; 1 )

Hope that helps.

James