>thanks hilmar your reply
>
>when i use this, working
>num1=total/100
>num2=round(fail/num1,2)
>
>but i sql, if fail is=8 and total is =21 I get %tage=263 when i use
>total/fail* 100
Precisely that's why I said that you probably need it the other way. To get the number of failures as a percentage of the total, you divide as follows:
Fail / Total * 100
In this case, you will get about 38%.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)