Average?

[#1]

Hi everyone,

Please help me with another formula for the average

I try this:

sum(value)/count(distinct monthyear)

But, It ignores zeros months.

Best regards,

Rodrigo

[settu_periasamy]

Hi,

Did you try without distinct..

Sum(value)/count(monthyear)

or

Avg(value)

[#3]

Hi,

I try without distinct, but I need the monthly average and the result is different from average y with con Avg(value) neither.

I need a function to count the months that are in the table and consider the zeros

Thank you,

[sunny_talwar]

Not sure I understand, 16.25 seems like correct average where your Sum(Value) = 130 and Count (monthyear) = 8 and 130/8 = 16.25. What are you expecting to see?

[#5]

Hi,

When I have the function count(monthyear) the result is not equal to 8 and when I have the function count (distinct monthYear) is not the result 8, so the do with that very long expression.

Best regards,

Rodrigo

[sunny_talwar]

Try this may be:

Max(TOTAL Aggr(Count(DISTINCT monthyear), Item))

[jonathandienst]

It will not count months that are missing (ie no entries containing that month). You will need to populate a master calendar with the missing months. This might help:

How to populate a sparsely populated field

[#8]

Thank you very much Sunnny

[sunny_talwar]

Not a problem. I am glad it helped.

Best,

Sunny