How to include Zero value on an AVG() Function?

[#1]

Ive got this on a Pivot table as Expression :

Avg(Aggr(Sum( costo_maximo),Semana,MP))

But the Avg only shows the result of the columns with a value.

Any suggestion?

Thanks!

[jagan]

Hi,

Instead of that expression try this

=Sum(Aggr(Sum( costo_maximo),Semana,MP)) / Sum(Aggr(1, Semana,MP))

Hope this helps you.

Regards,

Jagan.

[#3]

This one doesnt work, shows me the same rasult always, look i let you what i wantin an excel, hope this helps.

[swuehl]

Try deselecting option 'Suppress zero values' on presentation tab.

[#5]

This one was always deselected

[swuehl]

Then I think you need to post a sample file that demonstrate your issue.

I can't reproduce it with the option deselected.

[#7]

Thanks for everything, with your idea of the suprees i just get noticed, those ones are no "0",otherwise thery are missing values!