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?