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).