2 Replies Latest reply: Nov 26, 2014 5:22 AM by Martin Willoeper

# Set Analysis as variable into another set analysis

Hey Community,

i need your help with a set analysis problem. I have defined variables by using set analysis. If I put them into a textbox I get the right result.

Here two examples:

vStart_PriorYear

=if (vOhneAuswahl = 0,  date(AddYears(YearStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} today())),-1)),

IF(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))> today(),

0,

vEnd_PriorYear

=IF(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))> today(),

0,

If(MonthEnd(Max({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>} %Datum))<today(),

Now I would like to use those variables in another set analysis. And that is my PROBLEM. I cannot make it work!!!

Here is the set analysis that is not working.

= Sum({<%Datum={'>=\$(vStart_PriorYear)<=\$(vEnd_PriorYear)'}>} [Sales])

Thanks a lot!

Martin

• ###### Re: Set Analysis as variable into another set analysis

Could be something to do with the date format of the values in your variables. Can you post a document that demonstrates the problem?

• ###### Re: Set Analysis as variable into another set analysis

I have solved the problem myself.

I forget to exclude the selection in my calendar.

My working set analysis looks now like that.

= Sum({<Calendar.Jahr=, Calendar.Quartal=, Calendar.Monat=, Calendar.EindeutigerMonat=, %Datum={'>=\$(vStart_PriorYear)<=\$(vEnd_PriorYear)'}>} [Sales])

Thanks anyways for your quick response