Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try this expression.
=num(Count(DefectName)/Count(TOTAL DefectName))*100,'#.##%')
Regards,
Raghav
Hey Hi,
Use Num() Function available,
In your case:
num(Count(DefectName)/Count(TOTAL DefectName))*100,'#,##.00')
Hope this helps
Regards
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
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.
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.