AddMonths in set analysis?

[#1]

Hi,

Is it possible to use Addmonths in set analysis?

I want to rewrite this:

sum

({$ <BETBOKFD_IN = {">2008-06-30"}> }_ForsCounter)

With something like this:

sum

({$ <BETBOKFD_IN = {">=$(AddMonths(AVSERPERIOD,-15)"}> }_ForsCounter)

Is it possible and how do I write it (as the above code dosen't work)?

[#2]

Hi,

see the attached example.

God luck!

Rainer

[#3]

Thanks,

Now I can copy your syntax, I still doesn't work for me though. I'll have another try at it later.
I'll let you know.

Regards,
Christina

[#4]

Christina,

be aware of the date format. That´s number one of most of the problems by using "Set Analysis".

Rainer

[#5]

Hi again,

I've tried Rainer's soloution, but apparently I'm doing something wrong as his set analysis is working.
Therefore I attached my example.

All suggestions are welcome.

By the way my version is 8.5

Regards,

Christina

[Anonymous]

Hi,

Try this.....

sum

({<BETBOKF_IN = {"<=$(=date(max(addmonths(AVSERPERIOD,-15))))>=$(=date(max(addmonths(AVSERPERIOD,0)))))"}>} _ForsCounter)

Cheers.

Ad.

[#7]

Hi,

Tnks Abu, but it still doesn't work, pls se the attached file with the code. It's a very stripped bit of code just to show the problem.
To add the date is always a good idea though.

Christina

[#8 · Accepted solution]

Hi Christina,

it´s working now. You missed brackets in your expression and please avoid spaces.

Have a nice weekend!

Rainer

[#9]

Thanks very much Rainer,

I really appreciate you taking the time to correct my misstakes.
I found set analysis very useful, but a bit hard to get right.

I also wish you a nice weekend.

Christina