Variable is not woeking in Set Expression

[mhmmd_srf]

Hi All,

I have a variable v1 =Max(CstDate);

However in set analysis I am trying to use below syntax and it is throwing error:

=sum({<CstDate ={'<=Date('$(v1)','M/D/YYYY')'}>}OrderLineDueCount)

Could anyone please help me on this.

Thanks,

Sarif

[pokassov]

Hi

=sum({<CstDate ={"<=$(=Date(v1,'M/D/YYYY'))"}>}OrderLineDueCount)

[MK_QSL]

Or try this

=SUM({<CstDate = {'>=$(=$(v1))'}>}OrderLineDueCount)

[Anil_Babu_Samineni]

May be typo error

=SUM({<CstDate = {'<=$(=$(v1))'}>}OrderLineDueCount)

[saimahasan]

Try with this. It worked for me

=Count({<CstDate={'<=$(v1)'}>}OrderLineDueCount)

[Anonymous]

Why you use a variable?

May be try to put directly the max in your set analysis expression?

sum({<CstDate ={$(=Max(CstDate))}>}OrderLineDueCount)