Including a variable in Set analysis Expression

[sudhir0538]

Hi all

Please help me to correct these two not given any result but error set analysis expression.

1)=Avg({<IMQ.Date={$(=vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_  -10mm])

2)=Avg({<IMQ.Date={$(vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_  -10mm])

Please help me to resolve this.

Variable vs_Today holds today date.

[Gysbert_Wassenaar]

Try it like this: Avg({<IMQ.Date={$(vs_Today)},IMQ.Shift={'A'}>}[IMQ.DOLOMITE_Sieve_  -10mm])

[sudhir0538]

Hai Gysbert!

Thanks for your helpful answer. Both the expressions which I have mentioned are working fine,At the time of posting I didn't have the date data in my source, so it's gave nothing.

Thanks again Gysbert.