September 9, 200916 yr Newbies 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?
September 9, 200916 yr abs (chargeValue ) * if ( chargeOrAllow = "Allow" ; -1 ; 1 ) Hope that helps. James
Create an account or sign in to comment