Calculation in Crosstab Query

B

Bart

I have an output from my crosstab query below

Overall Total Closed Resolved
Beyond 13 12 1
Within 33 31 2

But I want to calculate using below formula
% Beyond = (12+1)/46
% Within = (31+2)/46

should I do the calculation on the report? Or on the query? How Should I do
this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab Query Calculation 7
crosstab query question. 3
Crosstab Query 0
Calculation on Report 1
crosstab query? 3
SUMPRODUCT where between 2 dates 3
Union query 8
Crosstab Query 2

Top