Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this,
=Num(Avg(CSAT),'#,##0.00') or in Properties->Number->Fixed to give 2 decimal..
Hope it helps
Hi,
Try this,
=Num(Avg(CSAT),'#,##0.00') or in Properties->Number->Fixed to give 2 decimal..
Hope it helps