cancel
Showing results for 
Search instead for 
Did you mean: 

How to Calculate further from RESULT in a Query

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello,

Can anybody throw some torch on this..

Thanks,

Sai.

Former Member
0 Kudos

Did you try using formula?

You will have to throw some more light what you have in rows and columns.