AnsweredAssumed Answered

rounddown formula in forms

Question asked by smawer on Dec 6, 2018

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

Outcomes