set analysis '=' modifier

[ilanbaruch]

hi all,

in my model i have an table with the below expression :

sum({<Date={'$(vMaxInvDate)'},[Calendar.Month]=,[Calendar.Year]=,[Calendar.Quarter]=,HolidayFlag=,Holiday=>} quantity)

when user select year 2020 it retrieves the  correct value regardless the selection of Month, Quarter ...

problem is when selected year is 2019\2018 and Month\ Quarter - calculation retrieves 0 unless unselect Month\Quarter

so the modifier '=' works only with current year 

any ideas ??

advanced thanks

[sunny_talwar]

How do you define $(vMaxInvDate) variable? Is this an expression based variable or hard coded?

[ilanbaruch]

expression based :

=date(Max(max_inv_date))

[sunny_talwar · Accepted solution]

May be you need to ignore selection in your year, month, quarter fields within this expression also? Can you try this

=Date(Max({1} max_inv_date))

[ilanbaruch]

Within the variable expression?

[sunny_talwar]

yes

[ilanbaruch]

thank you