Good Morning,
This report uses five tables. One table is the Customer table and the others are transactions for each department. The tables are linked on the Customer ID field.

There is also a Parameter that allows the user to select a Department. The departments are Sales, Service, Parts, or Rentals.
I then created a straight forward formula that selects the Sub-total amount from the appropriate table based on the value of the parameter.

...and a record selection formula, also based on the value of the parameter, which excludes records from the other tables by adding 10,000 days to the current date and specifying that only invoice dates greater than that should be included (which of course there are none).

The problem is that the record selection formula produces erroneous results, including values from other departments as if the IF statement did not exist. For example; if I remove the other conditions from the record selection formula, the results appear to be accurate.

All of the grouping and group sorting for this report seem fine. Can someone please tell me why my record selection formula is failing?
Thanks - Tom