2 decimal points on 'text in chart'

[#1]

We have the following expression on the text of our chart:

=Avg([Q5 The attitude of the operative])=

The chart is a gauge ranging from 0-10. The expressions gives a score which is along the lines of 9.256328; however, we want it fixed to 2 decimal places, i.e. 9.25

Can anyone suggest/highlight how we might do this? Assume it done by editing expression of 'text in chart' but struggling...

Any help would be appreciated.

Chris

[#2 · Accepted solution]

Hi Chris,

You can use the function Num(), the example would be like this:

    Num( Avg([Q5 The attitude of the operative]), '###,###.##' )

Try it, should work.

[Anonymous]

Properties->Number->Fixed Decimals 2

[#4]

you can use the num() function to fix that

[marthacano01]

Did you try?

=num(Avg([Q5 The attitude of the operative]),'###.##')