Summary Value Custom Calc
I have a card with a comparitive Gauge that shows YTD Rev against YTD Budget Rev. In the summary value i want to show the % of budget.
But i have a lot of beast calcs to get to where i am.
i have a beast mode category that groups of line items. Called Country Group
So i have line items:
France Std Margin
France Selling Exp
The formula in Country Group is
when Line item = France Revenue then 'France'
when line item = France Std Margin then 'France'
when line item = France Selling Exp then 'France'
So my card has Country group as Gauge name and then filtered on Country as well to equal France. Since I have many countries, but the gauge is meant to represent France.
my Beast mode % of Revenue Value is
when line item = France Revenue then 'YTD Actual ' / 'YTD Budget ' But I'm not getting the correct value
my YTD rev is say 75K and YTD Bud is 115K, but % is showing 105.7%
Not sure what is happeing
- 10.6K All Categories
- 13 Getting Started in the Community
- 29 Beastmode & Analytics
- 2.1K Data Platform & Data Science
- 59 Domo Everywhere
- 2.7K Charting
- 2.4K Ideas Exchange
- 1.3K Connectors
- 362 Workbench
- 300 Use Cases & Best Practices
- 499 APIs
- 118 Apps
- 48 News
- 753 Onboarding
- 1.1K 日本支部
- 4 Private Company Board