I have a graph that displays my company's net income vs. our budget. In order to calculate the net income, I use the following beast mode:
sum(case
when `Group 2 Name` = 'Sales' or `Group 2 Name` = 'Sales Returns' then `Amount`
when `Group 2 Name` = 'Direct Costs' or `Group 2 Name` = 'Protein Powder' then -1 * `Amount`
when `Group 0 Name` = 'Other Income/Expense' then `Amount`
else -1 * `Amount`
end)
My budget is stored in a field called:
Net Income (b)
To generate the summary number, I did the following, but for some reason it returns 0%:
sum(case
when `Group 2 Name` = 'Sales' or `Group 2 Name` = 'Sales Returns' then `Amount`
when `Group 2 Name` = 'Direct Costs' or `Group 2 Name` = 'Protein Powder' then -1 * `Amount`
when `Group 0 Name` = 'Other Income/Expense' then `Amount`
else -1 * `Amount`
end) / sum(`Net Income (b)`)
What am I missing? It might be worth noting that multiplying by 100 did nothing, it still returns 0.