Beast Mode for Excluding Null Fields

snarayanane

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