Problem with Syntax Set Analysis

[#1]

Hi there,

I have a great problem with Set Analysis.

I want to change my IF-Statements toSet Analysis expressions (I have a lot of if-statements and I have problems with the performance)

Can somebody help me to change following expression:

sum(if(RechnungsWJdatumJJ = varWVGJ and Rechnungsdatum <= addmonths(vHEUTE -1, -12) and _keyArtGruppen = '1' and BonusArtikel = 'N' and SatzKZ = varArtikeleinheit, Rechnungswert)),

My problem is that the chapter "Rechnungsdatum <= addmonths(vHEUTE -1, -12) " (comparsion YTD)

I hope, the community can help me

Thank's a lot

Klaus

[#2]

If any of your chart dimension fields are part of IF conditions, then it's not possible to replace the IF condition by SET Analysis, because SET analysis works for whole chart, not individually for each chart row.