Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
How do you define $(vMaxInvDate) variable? Is this an expression based variable or hard coded?
expression based :
=date(Max(max_inv_date))
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))
yes
thank you