Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙏🙏🙏
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
Hi @Arnaud35 ,
Has [Opportunite.Date_relance] format is the same as DD/MM/YYYY
yes
Hi @Arnaud35 ,
It would be better if you share some small chunk of data.