Set analysis % indicator

[Arnaud35]

Hello,

I have a problem with the formula below dedicated to a % indicator :

Thank you for your help 🙏

=sum({<[Opportunite.Date_de_fin_d_AO]={"<=$(=Date(Today()-30, 'DD/MM/YYYY'))"},[Opportunite.Date_de_fin_d_AO]={"*"},[Opportunite.Statut_Commercial]={"En Cours"},[Opportunite.Attribué]={"oui"}>}[Opportunite.EstOpportunite])/=sum({<[Opportunite.Date_de_fin_d_AO]={"*"},[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite])

[jbhappysocks · Accepted solution]

Hi. Remove the = from the denominator

=sum({<[Opportunite.Date_de_fin_d_AO]={"<=$(=Date(Today()-30, 'DD/MM/YYYY'))"},[Opportunite.Date_de_fin_d_AO]={"*"},[Opportunite.Statut_Commercial]={"En Cours"},[Opportunite.Attribué]={"oui"}>}[Opportunite.EstOpportunite])/sum({<[Opportunite.Date_de_fin_d_AO]={"*"},[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.EstOpportunite])