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
Try this one
LOAD * Inline [
Number
80.56
74.456
32.32
];
=num(Number,'##0.0')
Use you expression like these
= Num(Expresssion,'#,##0.0;(#,##0.0); ')
or
= Num(Expresssion,'#,##.#;(#,##.#);')
why don't you simply change in the number format tab and change that to 1 decimal place fixed?
Hello,
Try Num(CINDEX,'##0.0')
It will round to 1 decimal value
Thanks and Regards,
Ankita
use Ceil()