Division of Values
Hello Domo Ninjas - I'm trying to get a new value from a dataset, where I'm dividing 1 column by another. Its a strange way of measuring how much Sales is adding on Services to Product deals.
- I'm getting errors both in Beast Mode, when I try MOD(
ProdSales
,SvcsSales
) - And in DataFlows when I add a Calculator, attach it to the Dataset give a new column name, select the calculation type Division, select the 2 columns, and finally drag an output DataSet, name and save. When I run it, I get an error {{ ::getInvalidText(datasource) }}
Any advice would be great...I'm stuck
Thx,
Rich
Best Answers
-
Hi @major_ace if you are looking for a simple division, try this beast mode:
sum(`ProdSales`)/sum(`SvcsSales`)
2 -
Is your data clean? Meaning do you have values for all of your rows of data and are those values all in number format? That error message might indicate that Domo is trying to run a calculation on a text field.
If the data is clean, you could try
MOD(sum(`ProdSales`),sum(`SvcsSales`))
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
Hi @major_ace if you are looking for a simple division, try this beast mode:
sum(`ProdSales`)/sum(`SvcsSales`)
2 -
Is your data clean? Meaning do you have values for all of your rows of data and are those values all in number format? That error message might indicate that Domo is trying to run a calculation on a text field.
If the data is clean, you could try
MOD(sum(`ProdSales`),sum(`SvcsSales`))
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
No, some rows were discounted to 0 and some have no value, where the Product was sold with either a discount to 0 or no Services were sold at all.
0 -
Thank you both! I went with the un-nested version @MichelleH posted, and it worked great! For some reason, my earlier attempts at nesting were throwing errors.
0 -
@major_ace - the MOD() function is not the same as dividing two values. But, as long as you have the output you are looking for.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman4
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive