Formula help
I am trying to accomplish this: I want a report that will show me clients in a week how many times a record was made with the filter No Show So a client is booked - he does not show on Monday, on t...
Forum Discussion
Roxanne,
What does your application look like? How are the tables related and where do you want to run your report?
If I understand what you are asking, I think this will do what you want:
The Summary field on the Client table counts the Schedule records where the Outcome is No Show and the Date Created is during the current week.
The No Show Count in the Schedule table is a Look Up field from the Client. Every Schedule record, regardless of Outcome know how many No Shows happened this week.
Your report on the Schedule table has the filter No Show Count Look Up >= 2.
If your app is totally different than this, maybe it will give you an idea. Otherwise, please share the ERD of your tables.
Thank you. I have 2 tables
parent called Customer (holds client data) then it has tours as a child which shows how many times we hosted this client.
I created a summary field on the Customer table that shows me # of No Shows, which I can get on the tour table. But it shows me ALL customers even when I put in the filters - is equal or greater than 2
But this shows me ALL Customers that have been with us twice. If I use the filter no show than it only shows me the no shows and not the other tours associated to that client. so I need to scroll and visually identify them which as time goes on it will be huge.