I'm new to data analytics. This might be a simple solution but I could not find it after 2 weeks of trying. I have a column of numbers that represent wins and losses. Losses are represented as "0" and wins are represented as "1". Is there a way (an array formula) that I can create a dynamic win rate column? These values to get a running total like how I manually entered them in column B?
(w/L , Win %)
(0 ,00)
(1,.50)
(1 .67)
(1 .75)
(0 .60)
https://docs.google.com/spreadsheets/d/1781D5ZNJ4tKzIOhPjrfIW0JRLlbWNUwI6L_4APyYhP8/edit#gid=0