# subtracting a negative number

Options
Member

Could someone tell me how to write a beast mode if subtracting a negative number

ex. have a freight charge of 199.68 and want to subract a negative 95.36, the calculation is coming out to be 295.04 instead of 104.32

thanks

• Coach
Options

There doesn't seem to be an issue.  199.68-(-95.36)=295.04

If you want the answer to be 104.32, you need to add the two values together.

199.68+(-95.36)=104.32

I hope this helps.

DataMaven
Breaking Down Silos - Building Bridges
**Say "Thanks" by clicking a reaction in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
• Coach
Options

199.68 - (-95.36) = 295.32 is mathematically correct

if what you want is to subtract the absolute value of a column ... use ABS()

`depending of your case you can do this  several different ways, depending of your need Beastmode 1`field1` - ABS(`Field2`)Beastmode 2ABS(`field1`) - ABS(`Field2`)`

Domo Arigato!

**Say 'Thanks' by clicking the thumbs up in the post that helped you.