Average function's not working?

[Anonymous]

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?

[vishsaggi]

Can you share a sample to work on?

[Anonymous]

I am sorry, I cannot do that

[vishsaggi]

You can scramble your data and upload like mentioned here:

Preparing examples for Upload - Reduction and Data Scrambling