Rounding off!!!!!!!!

[#1]

   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

[nizamsha]

Try this one

LOAD * Inline [

Number

80.56

74.456

32.32

];

=num(Number,'##0.0')

[sunilkumarqv]

Use you expression like these

= Num(Expresssion,'#,##0.0;(#,##0.0); ')

                        or

= Num(Expresssion,'#,##.#;(#,##.#);')

[Anonymous]

why don't you simply change in the number format tab and change that to 1 decimal place fixed?

[ankitaag]

Hello,

Try Num(CINDEX,'##0.0')

It will round to 1 decimal value

Thanks and Regards,

Ankita

[buzzy996]

use Ceil()