Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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%
May be try this
sum({$<period = {">=$(=vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%
May be try this
sum({$<period = {">=$(=vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%
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