1 Reply Latest reply: Jul 10, 2012 8:35 AM by Mayil Vahanan Ramasamy RSS

    Text In Chart - Removing Decimal Places



      I have learnt an awful lot through Google, QlikCommunity and Trial and Error over the past few days but there are a few issues that I just can not solve.


      I know that there will be a simple solution to this, but I am trying to reduce some "Text in Chart" to 2 decimal places.


      The base expression I have in the Text in Chart field is:


      = Avg(CSAT)


      This is taking the average of our Customer Satisfaction score. It currently returns 80.0000 for a particular client.


      Please can somebody ease my frustration and let me know how to reduce this to 80.00 (two decimal places).


      Many thanks,