Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Please help me as I calculate the average of the months from January to March by item
Thanks
try this:
avg({<Month={'ene 2015','feb 2015','mar 2015'}>} Value)
Hi,
another way is to build the sum and devide through Count(Months)
Sum(Value)/Count(Distinct Month)
Greetings from EVACO GmbH, Munich
Martina
Thank you very much for your help,
But, consider as zeros in average?
Thanks,
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
Hi Martina,
I enter the formula for every month, but not averaged zeros
Thank you for your help