Sum Count(Distinct) Sales vs Budget

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?


Tagged:

Answers

  • 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.