Output For Zero Entry

Hello Everybody,

I once knew the answer to this, but I’ve forgotten it. In a Numeric field with a zero or blank entry, how can I arrange the output to be a dash ("-")? This is for Panorama 6.

Vic DiFranco

If you’re trying to do that in the data sheet, I don’t think you can. In a text display superobject, you could use a formula like

?(MyField = 0,"-", MyField)

That’s it, Dave. Now I remember.