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

    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,

                     date(AddYears(MonthStart(Min({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>}%Datum)),-1))))

       

      vEnd_PriorYear

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

           0,

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

                     date(AddYears(MonthEnd(Max({<%Artikelnr=,%Statistikklasse=,%KreditorNr=>}%Datum)),-1)),

                          date(AddYears(today(),-1))))


      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