HI All,
I have a text field which takes decimal values , i want to restrict(put validation) the field with precision of 22 which means user is allowed to enter 13 digits before decimal and 9 digits after decimal point not more than that . Also, i want to store the value as it is (no round off) .
Please can somebody help me with this .
Thanks in advance.
Discussion posts and replies are publicly visible
Hi Anu,
We have a function called fixed(). This function has number and decimals(The number of digits after the decimal that will be maintained. 2 by default) fields.
refer documentation here: fixed function
example: fixed(7.36819, 3) returns 7.368
7.368
In your case : fixed(ri!enteredValue, 9)