Flag_Hippo wrote:You've used for the same screenshot for both columns there. Instead of posting screenshots I'd recommend copy/pasting each of the column expressions directly into your replies since that way if there is an issue I can copy/paste from those myself and edit them which I cannot do with screenshots.
Oh, my bad. Ok, so this is "cnt_p_limp_call_copy" column:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise and lookup_actions_p.action LIKE 'CC%' and tourney_hand_player_statistics.position = 9 and tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.enum_f_cbet_action='F', 1, 0])
"cnt_p_limp_faceraise_copy" column:
sum(if[tourney_hand_player_statistics.flg_p_limp AND tourney_hand_player_statistics.flg_p_face_raise and lookup_actions_p.action LIKE 'CC%' and tourney_hand_player_statistics.position = 9 and tourney_hand_player_statistics.flg_p_open_opp and tourney_hand_player_statistics.flg_f_cbet_def_opp, 1, 0])
The whole stat expression:
(cnt_p_limp_call_copy / cnt_p_limp_faceraise_copy) * 100