cancel
Showing results for 
Search instead for 
Did you mean: 

Negative value formula

Former Member
0 Kudos

<p>What is a good formula for getting a negative value if another field result < 0? For example I have a NETCOST formula field that I want to have a negative result if QUANTITY field < 0. Any suggestions? Thanks</p>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Just use the formatting formula for the negative symbol and turn it on using your logic above.

Or.... If you REALLY want the negative value, think of this type of calc in the formula itself.

If QUANTITY < 0 then NETCOST - (2 * NETCOST) else NETCOST

The true negative value is the one that we did with the formula. It's the safer way. 🙂

    - Kathryn Webster (Report Design Consultant)
          Kat&#39;s News: http://diamond.businessobjects.com/blog/279


Answers (0)