Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to calculate the percent that a scoreline appears for any particular league but am having trouble with the calculation.
As you can see from the screenshot below, the figure against each scoreline is how many times that scoreline appeared for each particular league.
What I'm trying to do is have that figure as a percent but i'm struggling when trying to do the calculation to only use the games that were played for that league.
EG, Bundesliga 1 had 400 games played in total. so for the scoreline of 0-0 which occurred 57 times, the percent should be 14.25 (57/400).
However, my expression is doing 57/17018 which is the total games played across all leagues. Is anyone able to demonstrate how to do the calculation only based on total matches for each league instead of total matches for all leagues?
Thanks
If your current expression is say Count(MatchID) then try:
Count(MatchID)/Count(TOTAL <[League Name]> MatchID)