hola necesito ayuda para crear una stats que me arroje el promedio de sizing de OPEN RAISE en big Blind desde buton ,teniendo en cuenta solo los OPEN RAISE menores a 5 BB,lo intente de la siguiente manera
pl_avg_sizing_bu_or / pl_bu_or
colum 1 "pl_avg_sizing_bu_or"= sum(if[(tourney_hand_player_statistics.position=0
AND (tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb) < 5)
AND tourney_hand_player_statistics.cnt_p_raise > 0 , tourney_hand_player_statistics.val_p_raise_made_pct, 0])
colum 2 "pl_bu_or" = sum(if[tourney_hand_player_statistics.position=0
AND tourney_hand_player_statistics.flg_p_first_raise
AND (tourney_hand_player_statistics.amt_p_raise_made * 1.0 / tourney_blinds.amt_bb) < 5
, 1, 0])
no se cual es el error