Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need some help with ignoring selections.
my expression is:
sum({<Year=, Date={">=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))"}>} aggr( invQTY, invID, invQTY))
In this expression I want to ignore the year, but it doesn't work.
If I replace: aggr( invQTY, invID, invQTY) with: invQTY, it's working.
What am I doing wrong?
Thanks.
May be try this:
Sum({<Year=, Date={">=$(=AddMonths( YearStart (Today()),-12))<=$(=AddMonths( MonthEnd (Today()),-12))"}>} Aggr(Only({<Year>} invQTY), invID, invQTY))