topic Re: Set Analysis Date Period in App Development

Set Analysis Date Period

MAPSF1 — Tue, 23 Nov 2021 16:54:51 GMT

Hi,

I am trying to create a set analysis calculation which includes a date period. I want to see the last 12 date periods combined in one sum. The PERIOD field is just a combination of the YEAR & MONTH.

I created a variable (vCurrentPeriod) to house the Current PERIOD so that is a rolling calculation.

Sum({<YEAR=, MONTH=, PERIOD={‘>=$(=vCurrentPeriod -11))<=$(=vCurrentPeriod)’}>} SALES )

Can anyone see where I am going wrong?

Thanks in advance.

Re: Set Analysis Date Period

stevejoyce — Tue, 23 Nov 2021 17:44:30 GMT

is period a date field formatted like YYYYMM ?

vCurrentPeriod: =max(PERIOD)

Sum({<YEAR=, MONTH=, PERIOD={">=$(date(addmonths(date#('$(vCurrentPeriod)','YYYYMM'),-12),'YYYYMM')) and and <= $(vCurrentPeriod) "} >} SALES )

Re: Set Analysis Date Period

MAPSF1 — Wed, 24 Nov 2021 09:13:05 GMT

Yeah, the datefield is YYYYMM.

Re: Set Analysis Date Period

stevejoyce — Wed, 24 Nov 2021 11:06:01 GMT

Ok, try what i posted.

vCurrentPeriod: =max(PERIOD)

Sum({<YEAR=, MONTH=, PERIOD={">=$(date(addmonths(date#('$(vCurrentPeriod)','YYYYMM'),-12),'YYYYMM')) and and <= $(vCurrentPeriod) "} >} SALES )

Re: Set Analysis Date Period

MAPSF1 — Wed, 24 Nov 2021 11:18:53 GMT

thanks for the reply but there seems to be an error in the code? should there be a double and, and extra " marks?

Re: Set Analysis Date Period

stevejoyce — Wed, 24 Nov 2021 17:29:11 GMT

quotes are fine. i have an extract and, and a space. try this.

Sum({<YEAR=, MONTH=, PERIOD={">=$(date(addmonths(date#('$(vCurrentPeriod)','YYYYMM'),-12),'YYYYMM')) and <=$(vCurrentPeriod) "} >} SALES )