topic Re: Set analysis with yearend in App Development

Set analysis with yearend

Arnaud35 — Wed, 16 Feb 2022 10:29:59 GMT

Hello,

I have a problem with the formula below :

I wanted to filter the results on the year only

=sum(if([Opportunite.Statut_Commercial]='En cours',[Opportunite.Date_de_Commande]<yearend((31/12/2022)),[Opportunite.Montant_offre_finale]))

Many thanks for your help

Re: Set analysis with yearend

anat — Wed, 16 Feb 2022 10:37:15 GMT

=sum({<[Opportunite.Statut_Commercial]={'En cours'},[Opportunite.Date_de_Commande]={"<=$(=date(yearend(31/12/2022)))"}>},[Opportunite.Montant_offre_finale])

Re: Set analysis with yearend

Arnaud35 — Wed, 16 Feb 2022 11:00:57 GMT

Hello,

Thnak you for your proposal.

Unfortunately, i have a mistake as shown below on the screeshot

Re: Set analysis with yearend

bensca04 — Wed, 16 Feb 2022 12:22:21 GMT

One "=" is missing.

{"<=$(=date(yearend(31/12/2022)))"}

Re: Set analysis with yearend

Arnaud35 — Wed, 16 Feb 2022 13:29:38 GMT

A bracket is still missing. I don't understand

Re: Set analysis with yearend

bensca04 — Wed, 16 Feb 2022 13:34:22 GMT

Remove the comma behind the set analysis

Re: Set analysis with yearend

Arnaud35 — Wed, 16 Feb 2022 14:58:42 GMT

Thank you for your correction.

I don't understand because, the date calculated is 1899 instead of 2022 as i wrote

Re: Set analysis with yearend

bensca04 — Wed, 16 Feb 2022 15:20:35 GMT

The date must be between apostrophs ('31/12/2022') and the date format have to be the same as specified in the SET DateFormat statement at the top of your load script.

Re: Set analysis with yearend

Arnaud35 — Tue, 22 Feb 2022 08:11:50 GMT

I have no result even if the formula seems to be correct :

Re: Set analysis with yearend

Arnaud35 — Wed, 23 Feb 2022 17:05:57 GMT

I modified the formula as below :

=sum({<[Opportunite.Date_de_Commande]=yearend({"=$(=Date(Today(), 'DD/MM/YYYY'))"}),[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.Montant_offre_finale])

I have an error :

Re: Set analysis with yearend

Arnaud35 — Wed, 23 Feb 2022 17:07:17 GMT

=sum({<not IsNull([Opportunite.Date_de_Commande]),[Opportunite.Date_de_Commande]=yearend({"=$(=Date(Today(), 'DD/MM/YYYY'))"}),[Opportunite.Statut_Commercial]={"En Cours"}>}[Opportunite.Montant_offre_finale])