Beast Mode Formula Error: This calculation is too long
I currently have a case statement within a beast mode calculation that does as follows:
case
when `advertiser name` like '%Microsoft%' then 'paid'
(745 lines similar to the one above)
else 'NA'
end
I get error: Invalid Formula : This calculation is too long
Not sure on how to go about this. Any advice or direction on what to do would be great.
Best Answer
-
I fixed my error. I had copied the contents from an excel sheet cell that contained roughly 800K blanks cells that the beast mode calculation picked up on. Fixed this error by copying just the cells that contained text into Beast Mode.
0
Answers
-
I fixed my error. I had copied the contents from an excel sheet cell that contained roughly 800K blanks cells that the beast mode calculation picked up on. Fixed this error by copying just the cells that contained text into Beast Mode.
0 -
That's still one hell of a long beastmode. I don't know if long beastmodes have any performance issues but I can't help but think their has to be a better way to do this to save you the headache of having that many lines and I'm sure you'll run into the limit eventually (if you will add more lines over time). Might not need to worry about it now but you might want to consider having a separate data source of all the `advertiser name`'s stored in and do some dataflow to join to that to get it out of a beastmode.
**Make sure to like any users posts that helped you and accept the ones who solved your issue.**0 -
That is a really good point. I will need to try this.
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
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 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