I was trying to make positional chipev stats for spins, hu is easy, but 3 way I have it wrong somewhere, cause total 3way chipev is different. Maybe you can help me out:
Those are columns, which I then divide by cnt_tourneys to make cev stat for each position.
BTN - thats probably fine:
sum(if[tourney_hand_player_statistics.cnt_players=3
AND tourney_hand_player_statistics.position = 0 ,
tourney_hand_player_statistics.amt_expected_won, 0])
For others, there is a mistake somewhere, can you tell me what is wrong?
SB vs BB
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_summary.str_actors_p NOT LIKE '0%' ,
tourney_hand_player_statistics.amt_expected_won, 0])
SB vs BTN
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_player_statistics.position = 9
AND tourney_hand_summary.str_actors_p LIKE '0%' ,
tourney_hand_player_statistics.amt_expected_won, 0])
BB vs BTN
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p LIKE '0%' ,
tourney_hand_player_statistics.amt_expected_won, 0])
BB vs SB
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p LIKE '9%' ,
tourney_hand_player_statistics.amt_expected_won, 0])
BB vs SB & BTN
sum(if[tourney_hand_summary.cnt_players = 3
AND tourney_hand_player_statistics.position = 8
AND tourney_hand_summary.str_actors_p LIKE '09%' ,
tourney_hand_player_statistics.amt_expected_won, 0])