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.2K Product Ideas
 1.2K Ideas Exchange
 1.3K Connect
 1.1K Connectors
 273 Workbench
 1 Cloud Amplifier
 3 Federated
 2.7K Transform
 78 SQL DataFlows
 525 Datasets
 2.1K Magic ETL
 2.9K Visualize
 2.2K Charting
 434 Beast Mode
 22 Variables
 510 Automate
 114 Apps
 388 APIs & Domo Developer
 8 Workflows
 26 Predict
 10 Jupyter Workspaces
 16 R & Python Tiles
 332 Distribute
 77 Domo Everywhere
 255 Scheduled Reports
 66 Manage
 66 Governance & Security
 1 Product Release Questions
 Community Forums
 40 Getting Started
 26 Community Member Introductions
 67 Community Announcements
 4.8K Archive