Number Formatting

[#1]

Hi,

In one of my chart in qlikview application I formatted the number as fixed to two decimals and it is showing like 0.02,0.06 .....

I would like to see this as .02,.06....I have seen in few applications in this way but unfortunately couldn't replicate.

please help me in acheving this

Thanks

Murali Krishna

[Gysbert_Wassenaar]

The only way I can think of right now is by creating text values from them using the replace function. Something like replace(num(sum(Amount)),'.00'),'0.','.')

[aveeeeeee7en]

Hi

Try this:

if(Subfield(Num(Number,'#,##0.00'),'.',2)>=0,'.'&Subfield(Num(Number,'#,##0.00'),'.',2))

Also, see the Attachment.

Regards

Aviral Nag

[MarcoWedel]

Maybe extended to:

Dual(replace(num(sum(Amount)),'.00'),'0.','.'), sum(Amount))

?

Regards

Marco