Number formating Four zeros after decimal

[#1]

Hi

We have a table containg some cost. Everything is fine , but there is a record containing for zeros after decimal (52,771.0000), what qlikview is doing that it automatically add two zeros before decimal hence corrupting the data.(I am just displaying the cost in a table box)

How can i have the number in its original format.

Thanks & Regards

[Sokkorn]

Hi,

See sample NUM function below:

     NUM(1234,'#,###.##')         ==> 1,234.00

     NUM(1234,'#,###.####')     ==> 1,234.0000

Let try with your case.

Regards,

Sokkorn

[#3]

thanks sokkorn
i tried ur solution while loading from the database .. but it still doing the same .. transfering two zeros after the decimal to before decimal.
and if there is 3 zeros after the decimal it is transfering 1 to the right.. in any case it automaticaly fixing two zeros after the decimal

[Sokkorn]

Hi,

Use this one NUM(NUM#('1,234.00'),'#,###.####')

[#5]

nope.. not working
do i need to change any setting??

[Sokkorn]

Hi,

I think no. Can you provide sample data?

Regards,

Sokkorn

[#7]

[SunilChauhan]

CHART PROPERTIES----> NUMBER-> SELECT eXTERNAL PRICE-> FIXED TO 4

HOPE THIS HELPS

[#9]

i dont have any such option in NUMBER property
My Qlikview version is 11

[SunilChauhan]

go to chart properties ->............ Number

it's there