Since my records wont let me group the way I need to I need to exclude a very select set of records.
I'm sure there is a very simple solution to this question but it escapes me at the moment. Been a bad week
I need to include all records where [Closed Date] is YTD except those records where ([Payment Type] = "XP" and [Payment Date] = [Reopen Date])
Basically I need to exclude XP payments when the payment date = the reopen date. We has an issue where payments had to be recoded but when that was done all the payment dates were moved into this year so I need to exclude those specific payments to get an accurate count for the year.
Again, thanks in advance
I'm sure there is a very simple solution to this question but it escapes me at the moment. Been a bad week
I need to include all records where [Closed Date] is YTD except those records where ([Payment Type] = "XP" and [Payment Date] = [Reopen Date])
Basically I need to exclude XP payments when the payment date = the reopen date. We has an issue where payments had to be recoded but when that was done all the payment dates were moved into this year so I need to exclude those specific payments to get an accurate count for the year.
Again, thanks in advance