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