Round decimal number in calculated fields

  • Thread starter Thread starter rama
  • Start date Start date
R

rama

Hello
I am looking for some help to make a rounding adjustment in the
calculated fields in my query. What I wish to do is to round the
decimal numbers like this: >0.01 to <0.24 to 0.0, >=0.25 to <0.74 to
0.5 and >=0.75 to <1 to 1. Thanks in advance.
Rama
 
Hello
I am looking for some help to make a rounding adjustment in the
calculated fields in my query. What I wish to do is to round the
decimal numbers like this: >0.01 to <0.24 to 0.0, >=0.25 to <0.74 to
0.5 and >=0.75 to <1 to 1. Thanks in advance.
Rama
Click to expand...

Double the number and round to zero decimals, then divide:

Round(2.*<your expression>, 0) / 2
 
Back
Top