Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two separate set analysis calculations and I want to present them into one expression. I am having difficulty mainly because I am still struggling with set analysis.
Expression 1:
Sum ({$<Field={'Points'}>}Points)
Expression 2:
sum({$<Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},Year=,Month=>} Points)
Please can someone help me.
Is this what you want?
sum({$<
Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},
Year=, Month=, Field={'Points'}
>} Points)
Is this what you want?
sum({$<
Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},
Year=, Month=, Field={'Points'}
>} Points)