how to calculate the average?

[#1]

Hello everyone,

Please help me as I calculate the average of the months from January to March by item

Thanks

[ecolomer]

try this:

avg({<Month={'ene 2015','feb 2015','mar 2015'}>} Value)

[brenner_martina]

Hi,

another way is to build the sum and devide through Count(Months)

Sum(Value)/Count(Distinct Month)

Greetings from EVACO GmbH, Munich

Martina

[#4]

Thank you very much for your help,

But, consider as zeros in average?

Thanks,

[brenner_martina]

Hello,

the question is, if you want to get 0 or NULL in your formulas. p.e. you can enter the following formulas for every month:

If(Sum(Value)=0,Null(),Sum(Value))

than you can work with Count(Distinct Month)

Greetings from EVACO GmbH, Munich

Martina

[#6]

Hi Martina,

I enter the formula for every month, but not averaged zeros

Thank you for your help