How to combine Set Analysis with YTD Formula

[#1]

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

[#2 · Accepted solution]

Hi

This should work:

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

Let me know.

Thanks

Sabal