I am trying to select a group based on looking for a particular date range, but also including items within the group that are either before or after that range, if they meet other criteria.
Example: I would like to select all outstanding balances for clients who have a balance that is at least X number of days late based on (TABLE.CLIENTDATE). If ALL balances fell outside of the selected days late range, then the account would not be selected. If ANY balance falls within the selected days late range, then ALL outstanding balances would be selected, regardless of their days late status.
I've tried creating a parameter field that would hold the TABLE.CLIENTDATE selected date, then creating a counter formula (IF TABLE.CLIENTDATE <= @CLIENTDATE THEN 1 ELSE 0), putting that in the detail line, and then selecting a group based on a group total of greater than 1. However, I get an error message telling me that "A formula cannot refer to itself, either directly or indirectly"
What am I doing wrong?
TIA,
CAthy
Example: I would like to select all outstanding balances for clients who have a balance that is at least X number of days late based on (TABLE.CLIENTDATE). If ALL balances fell outside of the selected days late range, then the account would not be selected. If ANY balance falls within the selected days late range, then ALL outstanding balances would be selected, regardless of their days late status.
I've tried creating a parameter field that would hold the TABLE.CLIENTDATE selected date, then creating a counter formula (IF TABLE.CLIENTDATE <= @CLIENTDATE THEN 1 ELSE 0), putting that in the detail line, and then selecting a group based on a group total of greater than 1. However, I get an error message telling me that "A formula cannot refer to itself, either directly or indirectly"
What am I doing wrong?
TIA,
CAthy