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 Revenue
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
Comments
-
Hi,
I think you should do a straight sum('YTD Actual ') / sum('YTD Budget ') for your summary number
this will aggregate all countries
then in the edit mode you can add the filter for france to lock the card for just france or even better, you can leave it open to the user so they can use the analyzer and filter the card the way they prefer. this means you wont need multiple cards for each country and gives the user the ability to play with the card and look at the percent of budget as a whole or choose and specific country.
hope this helps
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
my formula was working before but since in this case the result was 91% of budget it showed as a green up arror. I basically want to if actuals is less than budget, show as a red down.
this was my original formula
SUM(`YTD Actual` / `YTD Budget`)
and it gave correct % in this case 91% of budget. which is not good (red down arrow)
0 -
gotcha, the fix for it in lame terms would be
(Sum(Actuals) / sum(Budget)) - 1 Then format summary number as percentage.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive