Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i have a big mistake regarding following calculated dimension:
if(date(Aggr($(Max_), PRODUCT_CODE))<$(T2), date(Aggr($(Max_), PRODUCT_CODE),null())
with this Max_ = date(Max({$<RicevConsum.POST_DATE={'<=$(=$(T1))'},RicevConsum.TIPO={CONS,REC}>}RicevConsum.POST_DATE))
This expression works only with <'dd/mm/yyyy' in place of $(T2), i need to filter the aggr results using a date stored in variable, instead of date value ('18/10/2010').
Many thanks at all.
Hi,
have you tried to quote variable T2?
...< '$(T2)'
- Ralf
Yes Ralph, i've tried this <'$(T2)' but the filter has no effects, results contains all possible dates.
Can you post an example app?
- Ralf
Sorry Ralph, but i can't post data.
You could load some demo data (inline?)...
- Ralf