Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to calculate the average?

Hello everyone,

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

Thanks

avg.png

5 Replies
ecolomer
Master II
Master II

try this:

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

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

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

Sum(Value)/Count(Distinct Month)

Greetings from EVACO GmbH, Munich

Martina

Not applicable
Author

Thank you very much for your help,

But, consider as zeros in average?

avg.png

Thanks,

brenner_martina
Partner - Specialist II
Partner - Specialist II

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

Not applicable
Author

Hi Martina,

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


avg1.png

Thank you for your help