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
You can use regexmatch() to acheive this
regexmatch("^-?\d{0,13}(\.\d{0,9})?$",ri!number)
I created this regex expression but it works untill Appian converts value into exponential form . Is this expected behavior ? or Am i doing something wrong?
Hi,
I am facing the similar issue now. Did you manage to solve this problem? Appreciate your response.
Thanks,
Arun
You can store this value into a seperate variable by using text function and do the validation on that variable.