Touble with AddMonth in set analysis

Anonymous — Wed, 30 May 2018 12:39:38 GMT

hye all,

I'm in trouble using addmonth in a set analysis.

In Load :

Load Date(Date#(DAT_CONSO_COJ,'YYYYMMDD'),'DD/MM/YYYY') as DAT_CONSO_CONS_NEW,

DAT_CONSO_COJ,

IDF,

Code;

BASE_TEST:

LOAD * INLINE [

DAT_CONSO_COJ, IDF, Code

20180502,1,A

20180502,11,A

20180503,2,A

20180503,12,A

20180504,3,A

20180505,4,J

20180601,1,A

20180601,21,A

20180601,11,A

20180602,2,A

20180603,3,A

20180604,5,A

20170502,1,J

20170503,2,A

20170505,3,A

20170505,13,A

20170506,6,A

20170501,1,J

20170602,2,A

20170603,3,A

20170604,4,A

];

Set Vdim = DAT_CONSO_CONS_NEW;

Set VAnneePrec = AddMonths($(Vdim),-12);

When I try to use Count({$<DAT_CONSO_CONS_NEW = {"=$(VAnneePrec)"}>}IDF) the result is the same than te current year.

Exemple attached (select from 02/05/2018 to 05/05/2018 for exemple)

Thanks.

Re: Touble with AddMonth in set analysis

sunny_talwar — Wed, 30 May 2018 12:54:20 GMT

Try using The As-Of Table

Re: Touble with AddMonth in set analysis

Anonymous — Thu, 31 May 2018 07:13:35 GMT

Thanks.

I'll try to do something right with that. It's not so easy as i coul magine 😉

I''l post the result if it's correct.

Edit : i post it.

topic Re: Touble with AddMonth in set analysis in App Development

Touble with AddMonth in set analysis

Re: Touble with AddMonth in set analysis

Re: Touble with AddMonth in set analysis