cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

rounddown formula in forms

Jump to solution

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

Labels: (1)
0 Kudos
Reply
1 Reply
Workflow Hero

Re: rounddown formula in forms

Jump to solution

I have found a solution for this using a javascript formula 'Math.floor(value)'

Example:

Math.floor(3.8) = 3

Hope this helps out anyone in the same situation.

Regards,

Stuart

Reply