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

[swuehl]

Francis,

as far as I see, you removed the data and objects from your qvw, so I can't see actual numbers (and I can't reload of course).

As far as I have seen in your script you played around with NullAsValue etc. which might be the solution.

I remember there were some issues with using that on a concatenate load, please check this:

http://community.qlik.com/message/137850

Hope this helps,

Stefan

[SunilChauhan]

sum(if( isnull(Budget),0,Budget))

or in script where Budget field available use this

if( isnull(Budget),0,Budget))

[francisvandergr]

Sorry but this will not help. I still see a '-' at a lot of records

[francisvandergr]

you can see the data with ctrl-t

[SunilChauhan]

can u share the sample .

you have attached the file which not reloaded .can u reload and share?

[francisvandergr]

Her i have another example. In QV on the dashboard it goes good. When i do sum(Budget-Costs). When i do this in my datamodel Sum(Budget-Costs) it goes wrong.

And the problem is i have to count in my datamodel.

[SunilChauhan]

see the attached file

hope this helps

[francisvandergr]

In dashboard it goes good but not in datamodel see Total.

[SunilChauhan]

ok  you need to check total field in script

weither calculation are correct.