on 07-07-2021 1:11 PM
hi if we use a field in a structure as number , can we restrict the decimal places to max 2 digit. Converting it to amount if causing error in calculation with other fields.
You can use ROUND function from Rule Expression Library to round off the number to 2-places
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Archana,
Thank you for the reply. But it satisfies only one of the cases i have.
if value is 7.44444 then it makes to 7.45 using round( 7.44444,2).
For below case it will not work.
1.But if i have value 6.2 and i what ot make it like 6.20 ( mainly want it in 2 decimal places ) then it do not work.
2. Next if value is 1.0 and i want to remove the zero means make it non decimal like 1 then also it will not work like using round (1,0)
Any workaround..
User | Count |
---|---|
74 | |
9 | |
8 | |
8 | |
7 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.