0 instead of -

[francisvandergr]

I have a qvw with a table and some fields. In my datamodel i wanna have a sum from some fields. I have an example

Project\Nummer 11000  has in the column Budget an '-'  . In the column Total i wanna have -2220.38

I wanna have 0 as number instead of -  in my table.

Can someone help me. I included an QVW file

[#2]

I would go to presentation tab of chart properties and replace NULL NUMBER value

change option to '0'  by replacing '-'

[swuehl · Accepted solution]

Hi Francis,

since I can't reload, I used a binary load of your qvw and a resident load of your table.

E voilá, it seems to work without any other change.

Strange.

Stefan

[francisvandergr]

Thanx all for help. In my script i stored the table first in a QVD and when i load it back it works.

indeed strange