Hi,
Is there any known issue about the avg function?
I have a field that count days per code. The think is that if in a pivot table I have this expression:
Avg(distinct Days) and has as Dimensions Name, store, code and Days.
The pivot table displays the fields properly, the avg is not correct for a few of them and I don't know why.
I have tried to do it manually
Sum (distinct days) / Count (distinct Codes)
But the results are not well neither.
Any idea?
