Set Analisys with month condition

[#1]

Dear all,

I´d like to use set analysis with a month condition for one of the fields, but I´m getting errors doing it.

Could you please seeing the script what I´m doing wrong? (the last sentece is giving me problems)

({<[Fehl.Mng.fremd]={">0"}>}(NAS))and
count({<[Vorlagennummer]={">0"}>}(NAS)) and
count({<[Meldungsart]={"Q2"}>}(NAS))and
count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

Thanks and regards.

Asier

[tresesco]

Problematic area -count({<Month([Angelegt am])=

<this expects a name of a field>

It would be somewhat like:  Count ({<YourMonthField={"$(=Month(AddMonths(Today(),-1)))"}>}

[#3]

Thanks treseco for the quick reply.

Where you write YourMonthField, could it be replace for count({<Month([YourMonthField])=...

I´m no getting any value with the suggested change.

Kind regards.

Asier

[MK_QSL]

({<[Fehl.Mng.fremd]={">0"}>}(NAS))and
count({<[Vorlagennummer]={">0"}>}(NAS)) and
count({<[Meldungsart]={"Q2"}>}(NAS))and
count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

You have provided set analysis but the aggregation function missing...

COUNT/SUM/AVG (YOUR ABOVE EXPRESSION)YourDimesion

[#5]

Yes. Sorry that was a paste mistake.

The error comes from the last sentence.

count({<Month([Angelegt am])=Month(AddMonths(Today(),-1))>}(NAS))

I´ve just changed in the scprit the Field [Angelegt am]) for Month([Angelegt am]) as Monat and now I have this sentence, which is still not working ...

count({$1<[Monat]={"<=$(=Month(AddMonths(Today(),-1)))"}>}NAS)

Any ideas?

[MK_QSL]

count({$1<[Monat]={"<=$(=Month(AddMonths(Today(),-1)))"}>}NAS)

Looks like your Monat is in different format.... You need to convert the data format to match something like below

What is the Monat format?