Jump to content
Software FX Community

RE: Display 'N/A' for null values

Software FX

Recommended Posts

When a NULL value is read from a database we replace it with a predefined value (CHART_HIDDEN) that should make chart "hide" the marker.


Juan Cegarra

Software FX, Inc.


-----Original Message-----

From: Chris Peterson [mailto:cpeterson@blueflameinc.com]

Posted At: Wednesday, September 27, 2000 3:30 PM

Posted To: Client

Conversation: Display 'N/A' for null values

Subject: Re: Display 'N/A' for null values

You may be asking' Why not just return 'N/A' from your query?

ChartFX is expecting a numeric, and gives an error if the result is a


"Chris Peterson" <cpeterson@blueflameinc.com> wrote in message


> I want to display 'N/A' on a chart when I get a null value from the


> I DON'T want to display zero, because that has a different meaning, that

> there is data, and its zero. Null means we don't have any data.


> How can I do this in ChartFX?


> Thanks for any help.



Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...