hy everyone !
I'm trying to have an average of an aggregate function.
I want to calculate all my amout for which my conditions are true so I did a set analysis
With my kpi object, I have the wrong result : without the zero values.
![chapil_0-1640785359460.png chapil_0-1640785359460.png](https://community.qlik.com/t5/image/serverpage/image-id/69354iC5DDAC749C8B142F/image-size/medium?v=v2&px=400)
So I would like to find the write result which is 64,83
Thanks for your help
PS : this is my formula
Avg({<[REGION]>}
Aggr(fabs(
sum({<Flag_Fait={'F_'} ,
MONTH =,
[CODE]= {"$(=GetFieldSelections([CODE] ,',', 1000))"},
[DATE] = {"<$(=date(addmonths(date(today(), 'DD/MM/YYYY'), -$(i)
),'DD/MM/YYYY'))"},
[REGION]>} AMOUNT
))
// pour prendre en compte également les comptes à 0 j'ajoute ceci:
,[REGION]))