subtracting a negative number
meadow_ryan
Member
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
**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"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
 All Categories
 1.7K Product Ideas
 1.7K Ideas Exchange
 1.5K Connect
 1.2K Connectors
 292 Workbench
 4 Cloud Amplifier
 8 Federated
 2.8K Transform
 95 SQL DataFlows
 605 Datasets
 2.1K Magic ETL
 3.7K Visualize
 2.4K Charting
 696 Beast Mode
 43 App Studio
 39 Variables
 659 Automate
 170 Apps
 442 APIs & Domo Developer
 42 Workflows
 5 DomoAI
 33 Predict
 13 Jupyter Workspaces
 20 R & Python Tiles
 388 Distribute
 111 Domo Everywhere
 271 Scheduled Reports
 6 Software Integrations
 113 Manage
 110 Governance & Security
 9 Domo University
 31 Product Releases
 Community Forums
 40 Getting Started
 30 Community Member Introductions
 98 Community Announcements
 Domo Community Gallery
 4.8K Archive