Hi,

Does anyone know how to rounddown a value in a calculated field?

'round' works however this will only round to the nearest decimal point.

For example; i have the value '4.85' and i would like this to be rounded down to '4'.

If i use 'round' then this will equal 5.

If i try to use rounddown([value]) i get the error: 'rounddown' is undefined

If this is not possible another option would be to remove or trim the decimal and value after decimal point. I am struggling with this method also. Any ideas?

I need this calculated live on the form (a workflow is not suitable).

Thanks

Stuart