Skip to Content
Former Member
Nov 06, 2008 at 09:10 PM

Displaying Positive/Negative numbers from a formula


I have the following formula that looks similar to this..

(Field1) - (Field2)

when field 1 is smaller then field 2 we know that the number will be a negative and the report will print a negative sign in front of the number.

Now here is the question, say (Field1) was equal to 10, and (Field2) was equal to 9 the formula would look like

(10) - (9)

and the report would print a positive 1. Is there anyway to format the formula to display a Positive sign in front of the number if it is positive, and a negative in front of the number if it is negative?

Thanks everyone for your help!