Sum Count(Distinct) Sales vs Budget

johnlam1

Hello All! I'm trying to do Total Sales divided by Total Monthly Budget in beast mode. The correct output should be $150/$500 but DOMO sum all lines under Budget column that gives out $150/$1300.

I tried Sum(count(distinct 'Store'), 'Monthly Budget') but no luck. Any solution?

RobSomers

You could use Magic ETL to group by store and month, and do a sum of Sales and maximum of Monthly Budget (assuming it stays the same the whole month). This would give you an output like this:

A May $120 $300

B May $30 $200

Then in your card just use a beast mode to calculate sales as percentage of budget.