New User: Calculated Field Sum Error; Cannot find resolution documentation
This is an elementary function, and I appear to be doing it correctly, yet I cannot get the correct outcome. I am using beast mode to add a calculated field, which combines the value of 2 raw data fields. However, the calculated field, no matter what I do, always returns blank values instead of a calculated value. What am I doing wrong here? See screenshots of data table and calcuation.
The calculated field is "Club Access Revenue," which results from adding the "cash" and "credit" fields. Row 1 should equal 22, row 2 rhould equal 22, row 3 should equal 20, etc. But they're all blank.
Best Answer
-
You could try this:
ifnull(`Cash`,0) + ifnull(`Credit`,0)
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0
Answers
-
Hi,
Try this :
SUM(IFNULL(`cash`,0) ) + SUM(IFNULL(`credit`,0) )
Hope this helps, tell me how it goes.
Ricardo Granada
MajorDomo@Lusiaves
**If the post solves your problem, mark it by clicking on "Accept as Solution"
**You can say "Thank you" by clicking the thumbs up in the post that helped you.1 -
Thanks for the input. That formula gave me the result of 22+0=924. So, still trying to figure it out. Thanks.
0 -
You could try this:
ifnull(`Cash`,0) + ifnull(`Credit`,0)
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
What does that data look like under this beastmode? There must be multiple rows of data for each CheckIn. If you use the aggregate SUM() function, it is going to total them all up, not just that one row.
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman0 -
This worked. Thank you so much for the help!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive