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
Hi,
try this:
Avg({<[date fin contrat]={">31/08/2018"},[Matricule facturation]-={'INTERNE'}>}Marge)
Hi,
try this:
Avg({<[date fin contrat]={">31/08/2018"},[Matricule facturation]-={'INTERNE'}>}Marge)
thanks a lot
you're welcome
good luck
after changement of date, it doesn't work
I think that it's because the formula exclude the empty value in date fin de contrat.
after changement of date, it doesn't work
I think that it's because the formula exclude the value of marge when in date fin de contrat the value is empty
I try this formula without success
Avg({<[Début de contrat]={"<=31/08/2018"},[Date fin de contrat]-={"<31/08/2018"},[Matricule facturation]-={'INTERNE'}>}Marge)
Yes because it is static inside the expression.
you can make it dynamic but how you will select a different date ?
how can make it dynamic ?
I create a variable = 31/08/2018
and when I want to change the date, i Change the value of the variable
you need to put your variable inside the expression, like this:
Avg({<[date fin contrat]={">$(your_variable_name)"},[Matricule facturation]-={'INTERNE'}>}Marge)