Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.
Properties->Number->Fixed Decimals 2
you can use the num() function to fix that
Did you try?
=num(Avg([Q5 The attitude of the operative]),'###.##')