I am Struggling with a Slice Row Filter Condition
Scenario: I have Club Members that can renew their subscriptions Annually. I create a record for each year and have an “Expired” status on the old record and the new record status is “Valid” (for 365 days)
I want to create a Slice for a “Reminder” Report that will run daily and check per the VisitorID if they have a “Valid” Year Permit or not. I want to ONLY send the Report to the Club Members that have their latest Record (by date) as “Expired”
I am basing the Report on a Slice and I am trying to Filter the Slice to give me the appropriate data that the Report will use.
My Slice Row Filter Formula: TOP(ORDERBY(FILTER(Permit, AND([PermitIndicator] = “Year”, NOT([PermitPaymentMethod] = “Resident”), NOT([PermitStatus] = “Valid”), SELECT(Permit[PermitDate],[VisitorID]=[_THISROW].[VisitorID]), [PermitDate]) ), [PermitDate], TRUE),1)
Gives me error: “Invalid structure: subexpressions must be Yes/No conditions”