Num Format in expression not working - model specific

[wandapec]

I have a really strange (And frustrating) problem. In one model the following formula results in the sum of sales showing as USD 2 344 232, as an example.

=num(sum(Sales),'USD # ##0')

However, I am now working on another model - on the same laptop, same Qlikview etc. - and the format looks like this USD 2 344 232 ##0. In fact I I can copy the object from the one model to the other and it will work in the one but not in the other.

It seems that in the one model, the format changes the number and in the new model I am working on the middle of the format is where the number goes and the USD and ##0 are just text that gets added to the front and the back.

Does anyone have any idea what the problem is? Is there a document setting that I am missing?

Thanks,

Steve

[#2]

Hi,

the properties "number" are unchecked the parameter Override Document Settings?

Can you upload the qvw for more detail?