Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
I have a Expression in that i have Decimal part is there so i want to round off that one Like;
present Input:
CINDEX |
---|
74.00156 |
26.00783 |
I want to get the this out put:
Cindex |
---|
74.1 |
26.1 |
can u help me how
thanks
Hi Suneel:
There are some rounding functions
1) Round
2) Ceil = Round Up
3) Floor = Truncate or Round Down
Hope it helps
Joaquin
Hi Suneel,
You this in your expression:
=Num(Your_Field,'##.#')
Thanks,
AS
u can use ceil,round,floor but how u r bringing ur output like that
74.1
The last parameter of this functions is an offset.
You could round/floor/ceil to 0.003 or 0.04 or 0.7
Not only to 0 or to +1
IF it is 74.56217
I want round it to 74.6 like that
Hi
round( 2.4 ) returns 2
round( 2.6 ) returns 3
round( 2.5 ) returns 3
round( 3.88 , 0,1 ) returns 3,9
round( 3.88 , 5 ) returns 5
round( 1.1 , 1 , 0.5 ) returns 1,5
Have a look at the online help
try ceil function!!
load ceil(ceil(ceil(Ceil(CINDEX,'0.0001'),'0.001'),'0.01'),'0.1') as CINDEX inline
[
CINDEX
74.00156
26.00783
74.56217
];
Try this,
Ceil(CINDEX,'00.1',1)
-Prabhu
Hi Sunil
If you have 74.01 and you want 75 you must use Ceil
If you have 74.99 and you want 74 you must use Floor
If you have (74.01 to 74.49 and want 74) or (74.50 to 74.99 and want 75) you must use Round
Three functions works with some decimals