Beast Mode Syntax error
Hi, I would greatly appreciate some help with this beastmode.
The idea is to calculate what % of the remaining sales quota for the quarter each open deal per salesperson is. I want to divide the Open deal value by (Quota  Value of all Won deals)
100000this is the quota, manual input
case when `Status` = 'Open' then (`Value` / (100000  SUM(case when `Status` = 'Won' then `Value` else 0))) else 0 end
Thanks in advance!
0
Best Answer

Try this
sum(case when `Status` = 'Open' then `Value` Else 0 end)
/
(100000  SUM(case when `Status` = 'Won' then `Value` else 0 end))
______________________________________________________________________________________________
“There is a superhero in all of us, we just need the courage to put on the cape.” Superman
______________________________________________________________________________________________2
Answers

And to be careful, though unlikely to happen, you can protect against "divide by zero" errors:
CASE
 If denominator is zero, result is zero
WHEN (100000  SUM(CASE WHEN `Status` = 'Won' THEN `Value` ELSE 0 END)) = 0 THEN 0
 else, do the real calculation
ELSE
SUM(CASE WHEN `Status` = 'Open' THEN `Value`) ELSE 0 END)
/
(100000  SUM(CASE WHEN `Status` = 'Won' THEN `Value` ELSE 0 END))
END
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
 7.3K All Categories
 13 Getting Started in the Community
 142 Beastmode & Analytics
 1.8K Data Platform & Data Science
 54 Domo Everywhere
 2K Charting
 1K Ideas Exchange
 904 Connectors
 237 Workbench
 342 APIs
 77 Apps
 19 Governance & Productivity
 235 Use Cases & Best Practices
 50 News
 473 Onboarding
 573 日本支部