on 07-02-2007 2:04 PM
Hi All,
Need help is query calculation,
My requirement is
I have few samples tested need to be shown in report
Zone1 sample1 Pass %
sample2 Not tested
sample3 fail
sample4 pass
<b> 3 (tested) 1(fail) 3-1/3 *100=66.67%</b>
Zone2 sample1 Pass
sample2 Not tested
sample3 pass
sample4 pass
<b>3(tested) 0(faild) 3-0/3 *100 =100%</b>
Zone3 sample1 Pass
sample2 Not tested
sample3 pass
sample4 pass
-
-
80(Total Zones) 7767 (total % ) 7767/80 = 97.08
I have to calculate based on Count of each reult..
How can I acheive this
Thanks,
Sai.
Hello,
Can anybody throw some torch on this..
Thanks,
Sai.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.