Displaying up to 2 decimal values

[#1]

Hi all,

I have a small function as sum(Runs)/Count(Dismissal). The o/p is coming in decimal points.

I want to show the o/p only up to 2 decimal points. I have tried with num#,round etc functions

but didn't get o/p as required. Please suggest me how to do it?

Thanks,

Shailesh

[#2]

where u want to show in chart or text box?

in chart means go to number tab >select integer or number which u want > give decimals also upto how many u want

or

if in list box

try like this

ceil(534.465,0.5)     then output like   >  534.46

[SergeyMak · Accepted solution]

Hi,

Try this

Num(sum(Runs)/Count(Dismissal),'#,##0.00 ')

Regards,

Sergey

[#4]

Expr: sum(Runs)/Count(Dismissal)

GO to Number Tab in the Chart...Select Fixed to : 2

Regards,

Heather

[ashishkalia]

HI

PLEASE CHECK ATTACH QVD THIS MAY HELP U....

CHEERS....

[#6]

Thank you Ashish..

Rgds,

Shailesh