Discussion board where members can get started with QlikView.
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?
Sure, divide the number by 100 then format the result to display two decimals.
View solution in original post