cancel
Showing results for 
Search instead for 
Did you mean: 

In Business Rules for numbers field can we restrict it to 2 places

0 Kudos

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.

View Entire Topic
Archana
Product and Topic Expert
Product and Topic Expert
0 Kudos

You can use ROUND function from Rule Expression Library to round off the number to 2-places

0 Kudos

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