Set Analysis with not isnull condition

[Arnaud35]

I have a problem on my set analysis below :

sum({<[Opportunite.Date_de_fin_d_AO]={"<=$(=Date(Today()-21, 'DD/MM/YYYY'))"},not isnull ([Opportunite.Date_de_fin_d_AO]),[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite])

[anat]

not isnull  is wrong in your set analysis:

for not null use something like below

Count({<actorname-={"''"},Status={'Open'}>} RequestID)

[Arnaud35]

I don't understand how to implement it on my request which is with a sum and not a count

[chris_djih · Accepted solution]

try:

sum({<[Opportunite.Date_de_fin_d_AO]={"<=$(=Date(Today()-21, 'DD/MM/YYYY'))"},[Opportunite.Date_de_fin_d_AO]={"*"},[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite])

[Arnaud35]

Thank you very much 🙏🙏🙏