AnsweredAssumed Answered

How to display a total of all records when only some records are selected?

Question asked by Tom_Droz on Jul 23, 2018
Latest reply on Jul 23, 2018 by philmodjunk

Here is an example of the issue: A real estate office has some showings that are awaiting confirmation.

 

I have a field that has a count of "1" in records that meet that criteria.

 

What I would like is to display the total of all the "1"'s even when all those records are not in the found set.

 

So if there are 5 showings awaiting confirmation, it would display the #5 on the screen even if all 5 are not in the current found set.

 

I created a summary field for "Total" but it only shows the total count of the displayed records.

 

There must be an easy way to do this. isn't there?

 

 

Thank you for any feedback!

Outcomes