Set analysis with yearend

[Arnaud35]

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

[anat]

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

[Arnaud35]

Hello,

Thnak you for your proposal.

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

[bensca04]

One "=" is missing.

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

[Arnaud35]

A bracket is still missing. I don't understand

[bensca04]

Remove the comma behind the set analysis

[Arnaud35]

Thank you for your correction.

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

[bensca04]

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.

[Arnaud35]

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

[Arnaud35]

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 :