Hello,
I have a member formula where the logic must change to evaluate the prior month and year to the current month and year for the same record. Here's a simplified version of my outline
DIM period where members are Jan to Dec
DIM years where members are FY15 to FY20
DIM costcenter where members are CC1, CC2, etc
DIM account where members are status, etc
I have 2 records
record 1: Jan, FY19, CC1, status
record 2: Jan, FY19, CC2, status
I need to evaluate record 2 and check if prior period = current period, and if prior year = current year, then set status = 5
I'm working with @prior() but am not getting the expected results - I'm hoping it's a simple logic error. Any thoughts is greatly appreciated - Thank you
cl