Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I want to count the number of client in current situation where , this client client statut = active in 12/2017 i used this expression but i dont know where is the problem
count({<DATE={$(DATE_SITUATION)},CLIENT_STATUT={$(={<DATE= {$(='201701'},='ACTIF'))}>} idclient))
May be this
Sum({<DATE = {$(DATE_SITUATION)}, CLIENT = P({<CLIENT_STATUT = {'ACTIF'}, DATE = {'201701'}>})>} PLACEMENT_ENCOURS_TND)
May be this
Sum({<DATE = {$(DATE_SITUATION)}, CLIENT = P({<CLIENT_STATUT = {'ACTIF'}, DATE = {'201701'}>})>} PLACEMENT_ENCOURS_TND)
Hello sunny thank you for your help , I used this expression
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)