Set analysis - calculating a period

[paul_ripley]

Hello

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

The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get 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)+09"},
team_description -= {'P&P','IT'},
Datasource = {'Actual'}, busarea = {PC}
>} $(vCurrency))

[sunny_talwar · Accepted solution]

May be try this

=Sum({$<period = {"$(=vStartPeriod_CY + 9)"},
team_description -= {'P&P','IT'},
Datasource = {'Actual'}, busarea = {PC}
>} $(vCurrency))

[paul_ripley]

Hi Sunny

Many thanks for your help

Paul