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

%3CLINGO-SUB%20id%3D%22lingo-sub-3023791%22%20slang%3D%22en-US%22%3ECharts%20Record%20%220%22%20when%20a%20Formula%20is%20in%20a%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3023791%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Roger1035_0-1638378823170.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F331002iACB8C8FCB69B6C84%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Roger1035_0-1638378823170.png%22%20alt%3D%22Roger1035_0-1638378823170.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20referenced%20Data%20Column%20has%20a%20Formula%20that%20will%20return%20a%20%22%22%20to%20the%20cell%20when%20there%20is%20no%20value%20to%20calculate.%26nbsp%3B%20%26nbsp%3BSo%20the%20cell%20appears%20EMPTY%20but%20the%20chart%20reads%20as%20a%20%22ZERO%22.%26nbsp%3B%20%26nbsp%3BThis%20only%20happens%20when%20there%20is%20a%20FORMULA%20being%20used%20to%20generate%20a%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3023791%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3024375%22%20slang%3D%22en-US%22%3ERe%3A%20Charts%20Record%20%220%22%20when%20a%20Formula%20is%20in%20a%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3024375%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1235286%22%20target%3D%22_blank%22%3E%40Roger1035%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20an%20alternative%2C%20make%20the%20formulas%20return%20NA()%20instead%20of%20%22%22.%20By%20default%2C%20charts%20treat%20%23N%2FA%20as%20empty%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0957.png%22%20style%3D%22width%3A%20305px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F331051i67558B9FDAD26463%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0957.png%22%20alt%3D%22S0957.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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