Hello all,
I am trying to calculate a function that lists all subscription orders (directory_qualifier in my example), where the order doesnt exist in any later period (i.e. the subscription is ending) but has also appeared in at least 12 previous periods. I have identified orders that are ending using E set analysis as below:
count({$<directory_qualifier =E({1<Financial_Period_YYYYMM={'>$(vSelectedPeriod)'}>})>} distinct directory_qualifier)
I have also been able to count how many periods the subscription appeared in using the below:
count({$<Financial_Period_YYYYMM = {'*'}>} directory_qualifier)
I'm struggling to bring the two together though, to give me a result set of subscriptions which have run for 12 period and finish in the selected period (vSelectedPeriod). Is this possible through just set analysis, or through a combination of if statement and set analysis?
Many thanks in advance for your help.
Noel