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
 10.5K All Categories
 8 Connect
 918 Connectors
 250 Workbench
 472 Transform
 1.7K Magic ETL
 69 SQL DataFlows
 477 Datasets
 202 Visualize
 255 Beast Mode
 2.1K Charting
 12 Variables
 17 Automate
 354 APIs & Domo Developer
 89 Apps
 3 Workflows
 20 Predict
 5 Jupyter Workspaces
 15 R & Python Tiles
 247 Distribute
 63 Domo Everywhere
 243 Scheduled Reports
 21 Manage
 42 Governance & Security
 179 Product Ideas
 1.2K Ideas Exchange
 12 Community Forums
 27 Getting Started
 14 Community Member Introductions
 55 Community News
 4.5K Archive