Charts Record "0" when a Formula is in a Cell

Copper Contributor

Roger1035_0-1638378823170.png

The referenced Data Column has a Formula that will return a "" to the cell when there is no value to calculate.   So the cell appears EMPTY but the chart reads as a "ZERO".   This only happens when there is a FORMULA being used to generate a value.

 

1 Reply

@Roger1035 

As an alternative, make the formulas return NA() instead of "". By default, charts treat #N/A as empty:

S0957.png