1 Reply Latest reply: Jul 10, 2012 8:35 AM by mayilvahanan ramasamy RSS

    Text In Chart - Removing Decimal Places

      Hi,

       

      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,

       

      Jonathan