Set Expression

[upaliwije]

Dear Friends

My following set expression show zero results. I think there is an error there. Pls help me to rectify it

[Anil_Babu_Samineni · Accepted solution]

May be this? I assume Date fields are good

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {"=$('<' & =Max(RENEWED_DATE))"}>} DISTINCT POLICT_NO)

OR

Count({<RENEWED_PREMI|UM = {'>0'}, RENEWED_DATE = {'<$(=Max(RENEWED_DATE))'}>} DISTINCT POLICT_NO)

[upaliwije]

Thanks Anil

Your second option works

[Anil_Babu_Samineni]

I think first one also should work, May be remove = sign for your understand you can learn yourself