Having trouble creating my first custom stats.

[shatteredx]

I'm trying to create my first custom stats, and I have no idea what I'm doing. I've read through some of the basics on here, but its a lot to take in all at once. Right now I'm trying to make stats for when a player is first to act and raises all in, and for when a player calls an all in from the big blind. When I click the validate button, PT4 says the statistic is valid, but when I load the HUD into my game I get this message: Expressions: Parameters on the left and right side of an operation must be compatible I don't understand why the program will validate but not implement these stats.

Here are my stats and columns.
RFI Allin:

(cnt_p_raise_first_in AND cnt_p_allin / cnt_p_open_opp) * 100

and BB Call Vs. All In Total

(cnt_p_bb_c_allin / cnt_p_bb_f_allin) * 100

and these are my columns for the last stat

cnt_p_bb_c_allin

sum(if[tourney_hand_player_statistics.position=8 AND
tourney_hand_player_statistics.enum_face_allin='P' AND
tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='C' , 1, 0])

cnt_p_bb_f_allin

sum(if[tourney_hand_player_statistics.position=8 AND
tourney_hand_player_statistics.enum_face_allin='P' AND
tourney_hand_player_statistics.flg_blind_def_opp AND lookup_actions_p.action='F' , 1, 0])

If anyone could tell me what I'm doing wrong it would be greatly appreciated. Thanks

[kraada]

BB Call vs All In Total looks fine, the issue is with your RFI Allin stat - you can't use AND in value expressions like that (I'm surprised it validated honestly). If you want both pieces to be true in order to add 1, you need to build a separate column ANDing the two pieces together within the sum(if[]) statement.