Message for null data

[devans_1]

Hi All,

In a Chart, on the presentation tab there is an input for 'Null Symbol'. Can this be populated with a variable - ie $(Error Msg) ? I can't get it to work for me. It just displays %(Error Msg) rather than the value of the variable.

[sujeetsingh]

Can you give the sample ?

There is no option for Expression !!

But yes one can do at expression level.

[flipside]

No you can't do it in the Null Symbol box, so as Ek tha Tiger says, do it at expression level. The easiest way is to create a second expression after your actual expression with this ...

=if(IsNull([ColA]),'Error Message',[ColA])

... where [ColA] is the label for your actual expression. You can then hide the actual expression if you wish.

flipside