I have recently created a report that shows the number of rows from my table for different yes/no attributes. Now, I would like to add another box that will show the average of these two look ups, as well as the difference between the results as seen on picture.
Asked
Active
Viewed 23 times
1 Answers
0
Sounds like simple math to me (unless I am misunderstanding your "Average" request.
Difference:
=DCount("*", "[Quote Lost Query]") - DCount("*", "[Quote Won Query]")
Average:
=(DCount("*", "[Quote Lost Query]") + DCount("*", "[Quote Won Query]")) / 2

ccarpenter32
- 1,058
- 2
- 9
- 17
-
thanks! that was much simpler than i had thought. tried using the totals tool rather than using equations. greatly appreciated. – Matt H Jun 29 '18 at 08:42