How to count values in a table where 2 fields are equal
I have a table where basically we take a snapshot of a work stack every week, in the table i have the weekend ending date the snapshot was taken and then the date the piece of work came in (this is linked to a master calendar with week ending dates)
I am trying to use the below formula to count the number of new in.
END_OF_WEEK = mater calendar end of week value for when the work came in
WEEKENDING_DATE = the week ending date that the snapshot of the work stack was taken.