How to combine Set Analysis with YTD Formula

Thu, 21 Aug 2014 12:54:45 GMT

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

Re: How to combine Set Analysis with YTD Formula

Thu, 21 Aug 2014 13:33:35 GMT

This should work:

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

Let me know.

Thanks

Sabal