Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Bonjour,
Ma formule ci-dessous ne fonctionne pas
=sum(if([Opportunite.Statut_Commercial]='En cours' and [Opportunite.Date_relance] = Date(today(),'YYYYMMDD'),[Opportunite.EstOpportunite]))
La date du jour est-elle bien traduite par Date(today(),'YYYYMMDD') ?
Hello
I had on problem with the format date which has been resolved.
The script below runs perfectly
sum({<[Opportunite.Date_relance]={"<=$(=Date(Today(), 'DD/MM/YYYY'))"},[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite]).
Thank you for the great support
Bonjour,
Essayez avec l'analyse des ensembles.
=sum({<[Opportunite.Statut_Commercial]={"En cours"},[Opportunite.Date_relance] = {"$(=Date(today(),'YYYYMMDD'))"}>}[Opportunite.EstOpportunite]))
-Ashutosh
Hello
I had on problem with the format date which has been resolved.
The script below runs perfectly
sum({<[Opportunite.Date_relance]={"<=$(=Date(Today(), 'DD/MM/YYYY'))"},[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite]).
Thank you for the great support