Forum Discussion

arsene49's avatar
arsene49
Helper I
3 years ago

Thanks Ahmed for the logic.

i checked the logic but your logic is not working for couple of scenarois like if there are continiuos 4 Wins (it is counting as 2)

ex. for below data, it is showing count as 2 which is wrong. it should be 1

also it shows 4 when there are 6 continious W .instead it should show 2

 

1Batman   L
2Batman   W
3Batman   W
4Batman   L
5Batman   W
6Batman   W
7Batman   W
8Batman   W
  • arsene49's avatar
    arsene49
    Helper I
    3 years ago

    Thanks much Ahmed for this refined logic.

     

    this is not working for below scenario - 

    if some has won 6/9 times continiously (WWWWWW), it still shows 1. instead it should show 2/3.

     

    it would be great if you can accomodate this scenario in your formula. appreciate your help on this.