Sum Count(Distinct) Sales vs Budget

johnlam1
johnlam1 Member
in Charting

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?

image.png


Tagged:

Answers

  • RobSomers
    RobSomers Coach

    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.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

Categories