subtracting a negative number
meadow_ryan
⚪️
in Magic ETL
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
0
Comments

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
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 
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 2
ABS(`field1`)  ABS(`Field2`)Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'1
Categories
 7.7K All Categories
 Connect
 917 Connectors
 242 Workbench
 474 Transform
 1.8K Magic ETL
 60 SQL DataFlows
 446 Datasets
 34 Visualize
 198 Beast Mode
 2K Charting
 8 Variables
 1 Automate
 348 APIs & Domo Developer
 82 Apps
 Workflows
 14 Predict
 3 Jupyter Workspaces
 11 R & Python Tiles
 241 Distribute
 59 Domo Everywhere
 241 Scheduled Reports
 15 Manage
 36 Governance & Security
 23 Product Ideas
 1.1K Ideas Exchange
 Community Forums
 15 Getting Started
 1 Community Member Introductions
 49 Community News
 18 Event Recordings
 579 日本支部