2 Replies Latest reply: Dec 21, 2009 5:49 PM by ben.shreeve RSS

    Getting Percentage in Guage chart

      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