Beast Mode for Excluding Null Fields

Let me explain with the following example


Store 1, Product A, Sales: $10, Profit $2

Store 1, Product B, Sales: $20, Profit $0


Beast mode calculation: sum(sales)/sum(profit).  


At an overall level, the value appears as (10+20)/(2+0).  


When I try to display at product level, due to the divisor being 0 for the Product B, the chart does not populate (says no data exists).  The particular entry alone can be displayed as null instead of the card becoming blank and saying no data exists

0 votes

· Last Updated

This discussion has been closed.