Num(Sum(Sales),'#,##0.000) and Num(Sum(Sales),'0,000.000')

[#1]

Hi there,

Is there any difference between

Num(Sum(Sales),'#,##0.00')

and

Num(Sum(Sales),'0,000.00')

I got exactly same format result. In another word, why do we use # sign in the num format?

Thanks a lot,

Steve

[Oleg_Troyansky · Accepted solution]

Hi Steve,

if I understand it properly, # is supposed to signify ANY DIGIT, while 0 is supposed to signify a MANDATORY DIGIT, but I agree with you, in my experience they seem to work identically. It could be coincidental though, so I'm sticking to the "proper" formatting string (the former in your example)

Cheers,

Oleg Troyansky

Upgrade your Qlik skills at the Masters Summit for Qlik - coming soon to Milan, Italy!

[#3]

Hi Oleg,

Thanks for your lighting fast answer! I think your explanation is convinced.

Thanks a lot!

Have a great weekend,

Steve

[swuehl]

I do see different results, of course your number should be smaller than 1000:

=Num(12.34,'#,##0.00')

12.34

=Num(12.34,'0,000.00')

0,012.34

(QV 12.0.20000.0 X64)

[#5]

Hi Swuehl,

That's very interesting. Let me have a try!

thanks,

Steve