I try to calculate plan numbers based on the number of sales resources in analytics. However, filtering this down in the analytics dashboard, I have the issue that not every subgroup has salespeople in every sales job group. Means, analytics is not showing results for the plan number if a group has zero salespeople in a specific job group. Unfortunately, I could not figure out how to use an if formula or to replace an error with zero. Any idea? Below is the query. The yellow-marked formula would need to have a condition check (e.g. "E" is a count of all Inside Sales Resources. If in a given group there are no Inside Sales Executives, the result should be zero).
2 Antworten
Prabhat Mishra (Salesforce) 
Forum Ambassador
Hi @Volker Roessler,
You can try using coalesce() to replace nulls with 0.
coalesce(E*10000,0) as 'J', coalesce(F*20000,0) as 'K', coalesce(G*120000,0) as 'M', coalesce(I*120000,0) as 'N'
