How to use the "totals" row to do another calculation

[Novaember]

Hello
Right now I have a table that shows process opportunities and defects by type.
Each row is a separate record and I count each process defect as 1
I have another calculation that counts opportunities.

Then I use the totals row at the bottom to tell me how many total process defects there are and how many total opportunities there are.

So I want to calculate the overall defect rate
[totaldefects]/[totalopportunities]

I can easily figure out the formula that calculates each row. But I can't figure out how to use the numbers in the total row. Any thoughts on how to do this?

Thanks

 

[Brianwarnock]

Don't know if I understand your question.
I assume that you use Sum in the Totals row to obtain [totaldefects] and [totalopportunities], now in the field row you wish to enter [totaldefects]/[totalopportunities] but don't know what to put in the Totals row?

From the dropdown select expression


Brian

 

[Novaember]

Don't know if I understand your question.
I assume that you use Sum in the Totals row to obtain [totaldefects] and [totalopportunities], now in the field row you wish to enter [totaldefects]/[totalopportunities] but don't know what to put in the Totals row?

From the dropdown select expression


Brian

It looks a little bit like this:
Opportunities, defects
12, 1
4, 1
totals: 16, 2

The totals row is SUM
I want to take the numbers from the totals row to find the rate defects/opportunities or 2/16

or should I just crete a query that gives me total opportunities and defects without using the totals row?

 

[Brianwarnock]

Selecting field opportunities and then selecting sum in the totals row will create a field Sumofopportunities, switch to SQL view to see this. Therefore in another column enter Rate: sumodefects/sumofopportunities and select expression in the Totals row.

Brian

 

[Novaember]

gotcha thanks!!