AVG if

[Anonymous]

Hi all,

My table is like that and

I want to calculate the average of Tx de marge but I Don't want to take the value if date fin contrat <31/08/2018 and if Matricule facturation = INTERNE

[Anonymous]

Yes I do it in other expression and that' ok

Avg({<[Date fin de contrat]={">$(Date de reporting)"},[Matricule facturation]-={'INTERNE'}>}Marge)

But it Always doesn't take the value marge when [date fin de contrat] is empty

I try this one

Avg({<[Début de contrat]={"<=$(Date de reporting)"},[Date fin de contrat]-={"<$(Date de reporting)"},[Matricule facturation]-={'INTERNE'}>}Marge)

all the value if [Début de contrat] before (Date_var) and I exclude the value of [date fin de contrat] before (Date Var)

[Anonymous]

but doesn't work

[YoussefBelloum]

Can't follow you anymore...

did your expected output change ?

because in your initial requirement you wasn't mentioning condition on field [Début de contrat]...

[Anonymous]

no I didn't