Set analysis % indicator

Arnaud35 — Fri, 04 Feb 2022 08:58:43 GMT

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])

Re: Set analysis % indicator

jbhappysocks — Fri, 04 Feb 2022 09:43:50 GMT

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])

topic Re: Set analysis % indicator in App Development

Set analysis % indicator

Re: Set analysis % indicator