Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi
This should work:
Sum({$<Nature={Actual},Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)
Let me know.
Thanks
Sabal
Hi
This should work:
Sum({$<Nature={Actual},Year=, Month=, Week=, DateField=, DateNum={">=$(=Num(YearStart(Max(DateNum))))<=$(=Max(DateNum))"}>}€)
Let me know.
Thanks
Sabal