topic Re: Set Analysis with not isnull condition in App Development

Set Analysis with not isnull condition

Arnaud35 — Mon, 31 Jan 2022 08:00:25 GMT

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])

Re: Set Analysis with not isnull condition

anat — Mon, 31 Jan 2022 11:03:39 GMT

not isnull is wrong in your set analysis:

for not null use something like below

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

Re: Set Analysis with not isnull condition

Arnaud35 — Mon, 31 Jan 2022 12:31:27 GMT

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

Re: Set Analysis with not isnull condition

chris_djih — Mon, 31 Jan 2022 13:46:51 GMT

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])

Re: Set Analysis with not isnull condition

Arnaud35 — Mon, 31 Jan 2022 13:53:03 GMT

Thank you very much 🙏🙏🙏