13 Replies Latest reply: Dec 11, 2017 4:22 AM by Tresesco B RSS

    Format number within expression

    Gerhard Laubscher



      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