Format number correctly

[Lukas_H]

Hello,

i'm loading numbers from a file wich look like 0000000000999.

With the num() function i get the number 999, but i want to have 2 decimals like 9,99.

However everytime I try to format it like num(CollumName,'#.###,#0') it doesn't take the last 2 Numbers as decimals, qlikview adds 2 zero's and it looks like 999,00.

Does anyone know how to format the collum so that the last 2 numbers are the decimals?

[Gysbert_Wassenaar · Accepted solution]

Sure, divide the number by 100 then format the result to display two decimals.