SET ANALYSIS

[Arnaud35]

Hello,

 have the following error returned in my load script below : "Error in expression: ')' expected"

=Sum(if{[Opportunite.Statut_Commercial]='En cours' and [Opportunite.Date_relance]={"<$(=Date(Today(), 'DD/MM/YYYY'))>"}[Opportunite.EstOpportunite]))

Thank you for your help 🙏🙏🙏

[Arnaud35]

Hi @abhijitnalekar 

I tried with a set analysis

=sum({<[Opportunite.Statut_Commercial]]={'En cours'}>},{<[Opportunite.Date_relance]={'$(='<='&Date(Today(),'DD/MM/YYYY'))'}>}[Opportunite.EstOpportunite])

It's correct but i have no result

[abhijitnalekar · Accepted solution]

Hi @Arnaud35 ,

Has [Opportunite.Date_relance] format is the same as DD/MM/YYYY

[Arnaud35]

yes

[abhijitnalekar]

Hi @Arnaud35 ,

It would be better if you share some small chunk of data.

[Arnaud35]

Hi @abhijitnalekar 

I can share this kind of data.

Tell me if it's enough