Skip to Content
0
Former Member
Jul 02, 2007 at 01:04 PM

How to Calculate further from RESULT in a Query

8 Views

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.