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

[Arnaud35]

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