Converting solid number to percentage.

[rofa84]

Hi, 

I'm very new to Qlick Sense and I'm having trouble converting  number 22.09 into 22.09%. I imported the number directly from an excel file. I used both Customize and Number for formatting option. 

I've tried "#.##0,00% or #,##0.00%" but it converted to 2209%. Please help me

[marcus_sommer · Accepted solution]

Just use: num(22.09 / 100, '0.00%')

- Marcus