Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you post your app?
Hi,
NUM(NUM#('1,234.00'),'#,###.0000')
Check that the decimal and thousand separators are OK with your local settings.
Hope that helps.
Miguel
Hi,
It working for me by using NUM(ExternalPrice,'#,###.####') AS [No2]
See in the attached file.
Regards,
Sokkorn
The above mentioned problem was due to the internal configuration of SAP.