expression help

[#1]

Hi,

This will probably be simple but we have the following expression:

avg([Tenancy_Length_Days])/365

It works; however, currently provides a number with about 10 decimal points (8.4483735659404). Can yone advise how to add to this so it only shows 2 decimal points?

Cheers

Chris

[Anonymous · Accepted solution]

round ( avg([Tenancy_Length_Days])/365 , 0.01 )

[sujeetsingh]

Just go to the Number Tab in properties and set Fixed to Decimals =2

[#4]

Go to properties and then to number tab.Select the expression and then in number expression setting select fixed to and change the number to 2.

This will work.

If it is not a chart, use round functin as mentioned by Bill.

[rustyfishbones]

NUM(AVG([Tenancy_Length_Days])/365,'#,##0.00')

[dmohanty]

Hi,

Go to Properties of the Chart>>Number Tab>>Select the expression>>Number Format settings 'Fixed To' : 2 decimals