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.” -Superman
______________________________________________________________________________________________0 -
I have a sample in the screenshot I attached earlier does that help?
Steve
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有