11 Replies Latest reply: Apr 9, 2015 3:33 PM by Sunny Talwar RSS

    Format number within expression

    Gerhard Laubscher

      Hi,

       

      How can I limit the number of decimals within my expression?

       

      I have an expression in my chart title, which is supposed to show me 22% but I don't know how to format it, so it shows 0.2212341241 or something. I can of course multiply with 100, but I want it to round off (have no decimals, or just one is also okay).

       

      Here is the title of my gauge chart:

       

      ='Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100