Why does the percentage change calc in Beast mode show 100% all the time?
I have a beast mode calculation that calculates % change in sales but the result in domo is always 100%. Below is my bbeast mode code. Any ideas?
(((CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE) THEN Target.`RetailSales` else 0 END)  (CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE)1 and MONTH(Target.`ForDate`) <= MONTH(CURRENT_DATE) THEN Target.`RetailSales` else 0 end))/(CASE WHEN YEAR(Target.`ForDate`) = YEAR(CURRENT_DATE)1 and MONTH(Target.`ForDate`) <= MONTH(CURRENT_DATE) THEN Target.`RetailSales` else 0 end)) as PcntChangeSalesVsPY
Thanks,
Steve
Best Answer

Resolved:
Depending on your data structure, I found that adding a "sum" in the calcuation fixed the issues; e.g Sum(y2/y1)
Hope that helps the next person.
0
Answers

This probably has to do with the structure of your data set. Keep in mind that beastmodes are only able to look at a single "row" of your data at a time. Would you mind sharing a few sample rows of your data so that we can help troubleshoot?
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman0 
I have a sample in the screenshot I attached earlier does that help?
Steve
0 
Resolved:
Depending on your data structure, I found that adding a "sum" in the calcuation fixed the issues; e.g Sum(y2/y1)
Hope that helps the next person.
0
Categories
 All Categories
 1.3K Product Ideas
 1.3K Ideas Exchange
 1.4K Connect
 1.1K Connectors
 281 Workbench
 2 Cloud Amplifier
 4 Federated
 2.8K Transform
 83 SQL DataFlows
 541 Datasets
 2.2K Magic ETL
 3.2K Visualize
 2.3K Charting
 518 Beast Mode
 26 Variables
 555 Automate
 129 Apps
 408 APIs & Domo Developer
 18 Workflows
 28 Predict
 12 Jupyter Workspaces
 16 R & Python Tiles
 343 Distribute
 85 Domo Everywhere
 257 Scheduled Reports
 1 Software Integrations
 81 Manage
 80 Governance & Security
 2 Product Release Questions
 Community Forums
 41 Getting Started
 27 Community Member Introductions
 78 Community Announcements
 4.8K Archive