Hello guys,
I need help in calculating averages; pls have a look at my example: in the upper table I show all the participants to a championship and in the lower one I’d like to show the averages of them.
The averages for every season must be calculated in this way: Season number of participants of each age / Number of races of the season
The total averages must be calculated in this way: Total number of participants of each age / Total number of races of the seasons
I currently use this formula: Sum(PartecipantiRP)/Count(IdGaraRP)
But It’s wrong because Qlik considers only the races where has been at least one participant and not all the potential race for every season.
Should anybody help me with the right formula, pls?
Thanks.
N.
