Two Set Analysis calculations into One Expression

[simongoodman]

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.

[calvindk · Accepted solution]

Is this what you want?

sum({$<

     Date={">$(=MonthStart(Max(RollMthYr), -12)) <=$(=MonthEnd(Max(RollMthYr)))"},

     Year=, Month=, Field={'Points'}

       >} Points)