Another set analysis period question

[paul_ripley]

Hello

I am trying to do some set analysis within a table,  I want to take range from the start period to period 9

The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get to the range  201900 to 201909 into the set analysis

For  example I tried the below but it didnt seem to work.  Can you see what i am doing wrong ?

Many thanks Paul

sum({$<period = {">=$(vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%

[sunny_talwar · Accepted solution]

May be try this

sum({$<period = {">=$(=vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%

[Brett_Bleess]

Paul, did Sunny's post get you what you needed?  If so, please do not forget to return to your post and properly close it out by using the Accept as Solution button on Sunny's post to give him credit and let the other Members know that worked.  If you did something different, please consider posting that and mark it to close out the thread.

Regards,
Brett