Hi, first post here. I have 2 columns Home and Away listing the number of goals scored. There are many rows. I am trying to use Power Pivot to find particular scorelines like 0-0 or 1-1 as a % of the total number of matches. Logically this would look like countif(and(home=0,away=0)) / count(home). Something like that. In the end I just want to know that 10% of games had a scoreline of 0-0.
Thanks to anyone out there who has the time to help a nitwit like me.
Thanks to anyone out there who has the time to help a nitwit like me.