on 10-21-2006 2:45 AM
<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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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's News: http://diamond.businessobjects.com/blog/279
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.