Getting Percentage in Guage chart

[#1]

Hi, I have a guage chart that I'm using, however I want to show the percentage on the chart too, so I have added the text, using expression:

=(Sum ((IF(Type='AA',[Budget Amount]))))/(Sum ((IF(Type='BA',[Budget Amount]))))*100

However, there are a few problems, namely it doesnt have the % symbol after it and its not limited to any decimal places- how can I change this expression to include the % text after it and to only display 1 d.p. so it looks like this:

24.1 %

instead of 24.12333311222445511

Cheers

Ben

[#2 · Accepted solution]

Hi Ben,

Dis you try using the NUM function?

= NUM( expresion, '#,##0.0 %')

I hope this help you.

Best regards.

[#3]

Thanks very much! Just what I was after!