1 Reply Latest reply: Aug 21, 2014 9:33 AM by Sabal Saxena RSS

    How to combine Set Analysis with YTD Formula


      Hello together,

       

      i habe two formulas:

      The first forumula isYTD

       

      Sum({<Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)

       

      The second Formula is the Set Analysis

       

      Sum({$<Nature={Actual}>}€)

       

      How I get this two formulas in one formula.

       

      Thank you