Expression help

[danielnevitt]

Hi,

I have the following expression and I would like to add where trade_dt is less than a variable vyesterday.

Sum(aggr(sum(DISTINCT pos_lots),pcr_num))

Let vYesterday = Date(Today()-1,'DD/MM/YYYY');

Regards,

Daniel

[tresesco]

May be this?

Sum(aggr(sum(DISTINCT {<trade_dt={'<$(vYesterday )'}>}pos_lots),pcr_num))

[sunny_talwar]

or this:

Sum(Aggr(Sum(DISTINCT {<trade_dt = {"$(='<' & vYesterday)"}>} pos_lots), pcr_num))