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 🙏🙏🙏
Hi @Arnaud35 ,
Has [Opportunite.Date_relance] format is the same as DD/MM/YYYY
Hi @Arnaud35 ,
Please correct the expression as below.
Sum(if
([Opportunite.Statut_Commercial]='En cours' and
[Opportunite.Date_relance]={"<$(=Date(Today(), 'DD/MM/YYYY'))>"},[Opportunite.EstOpportunite]))
Thank you for your reply but it doesn't work as shown below.
What can I do ?
Hi @Arnaud35 ,
can you please let me know what you are looking for less than today's date or equal to
[Opportunite.Date_relance]={"<$(=Date(Today(), 'DD/MM/YYYY'))>"}
Thank you for your question.
I want to check opportunities for which the "Date de Relance" is less or equal to the date of the current day.
Regards
HI @Arnaud35 ,
Try below
=Sum(if
([Opportunite.Statut_Commercial]='En cours' and
[Opportunite.Date_relance]="$(='<=' & Date(Today(), 'MM/DD/YYYY'))",[Opportunite.EstOpportunite]))
Hi @Arnaud35 ,
Is it possible to share some sample data?
What kind of sample data can I send to u ?
i tried with this set analysis. it doesn't work
sum({<if([Opportunite.Statut_Commercial]='En cours' and [Opportunite.Date_relance]={"<$(=Date(Today(), 'DD/MM/YYYY'))>"})>}[Opportunite.EstOpportunite])