set analysis with p() funciton

[souadouert]

Hello,

I Used this expression to count client , with activ statut IN 20171229

COUNT(DISTINCT {<CLIENT_ID=P({<statut_client={'actif'},DATE={'20171229'}>}),DATE={$(DATE_SELECTION)}>}CLIENT_ID)

so NOW I NEED  to modify this expressin , I want to replace DATE={'20171229'} with  the MIN(DATE) between

20171229 and DATE_SELECTION

[sunny_talwar]

This

Count(DISTINCT {<CLIENT_ID=P({<statut_client={'actif'}, DATE = {"$(=RangeMin(20171229, DATE_SELECTION))"}>}), DATE={$(DATE_SELECTION)}>} CLIENT_ID)

Is your DATE field in number format?

[souadouert]

Hello sunny ,

Yes in number format

[sunny_talwar · Accepted solution]

So did this work?

Count(DISTINCT {<CLIENT_ID=P({<statut_client={'actif'}, DATE = {"$(=RangeMin(20171229, DATE_SELECTION))"}>}), DATE={$(DATE_SELECTION)}>} CLIENT_ID)

[souadouert]

Thank you sunny