only 2 digits after decimal point.

[#1]

Hi ,

In list box, i written an expression i.e; =Count(DefectName)/Count(TOTAL DefectName))*100

it getting the value like this 31.8012658925 , but i want to display only 2 digits after decimal point. i.e; 31.80.

How can i solve this.

Thanks

[raghavsurya]

Hi,

Try this expression.

=num(Count(DefectName)/Count(TOTAL DefectName))*100,'#.##%')

Regards,

Raghav

[rahulgupta]

Hey Hi,

Use Num() Function available,

In your case:

num(Count(DefectName)/Count(TOTAL DefectName))*100,'#,##.00')

Hope this helps

Regards

[martin59]

Hi,

You have to do something like this :

num(Count(DefectName)/Count(TOTAL DefectName))*100,'# ###.##%', '.', ' ')

num() function parameters :

num(Number, Format, Decimal Sep, Thousand Sep)

Hope that helps you

Martin

[#5]

Hi,

     Goto listbox properties->Number tab-> Select Override Document Settings to enable the properties below and then select Fixed To - 2 decimals. That should suffice.

Thanks.

[#6]

Hi,

     Goto listbox properties->Number tab-> Select Override Document Settings to enable the properties below and then select Fixed To - 2 decimals. That should suffice.

Thanks.