calculating average with conditions

[Qlikuser09]

I am calculating the average in Qliksense bar chart, this is the formula I'm using

Sum(Value)/Count((no of groups)), when I do this some of the averages are correct and some of the averages are incorrect, then I found that they are only taking into account values greater than  0. so I want to add a condition to my formula, to include values only that are greater than zero. Any help on this??

[anthonyj · Accepted solution]

Hi @Qlikuser09 ,

If you only want to count Values that are greater than 0 you can add a set analysis to exclude 0's.

Sum({$<Value={">0"}>}Value)

Take in to account whatever is done in the numerator may have to be reflected in your denominator as well depending on your data structure.

Thanks

Anthony