Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
but doesn't work
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]...
no I didn't