Decimal and percentage num

[#1]

Hello;

I have an expression in a chart that equals to say 21.7893 I want to show it as 21.8%, so percentage format with one decimal. How can I do it?

[ciaran_mcgowan]

Num(FieldName, '0.0') & '%'

[sunny_talwar · Accepted solution]

May be one of these

Num(Expression, '##.0%')

or

Num(Expression/100, '##.0%')

[ciaran_mcgowan]

Make sure you keep the % sign out of the expression or else, it will divide the field value by 100. So for 21.7893:

Num(FieldName, '0.0%') will equal 0.2% (.217893% narrowed down to 1 decimal place)

[#5]

great, it's Num(Expression/100, '##.0%'). Thanks!

[vishsaggi]

Try this:

Num(<FieldName>, '#,##0.0%')

OR

Go to Number tab in properties window, select field name and in number format settings select as below:

[#7]

Hi!

I'm sorry to refloat up this topic but I have a question.

I have one expression with the same configuration format that you, but my result instead 100.0% is 100,000.0% and I don't understand why.

Do you know if it could be a cause of a bad configuration? As curiosity, if I change dots per commas, in expression and number configuration, the result is 100,0%.

Thank you very much!!!!

Edit.: Solved! Setting dots per commas in the script.