AnsweredAssumed Answered

rounddown formula in forms

Question asked by smawer on Dec 6, 2018



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