Count hands when a specific RFI size is used by position

[ttesone]

So, I managed to create a column with this definition:

sum(if[position_type = 2 and cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.amt_p_raise_made = 2 * cash_limit.amt_bb, 1, 0])

It counts the amount of times a player raised to 2bb from EP. It seems to be working OK. Now, when I try to modify it to count the amount of times a players raised to 2.5bb from EP, it doesn't work anymore. I only modified on variable:

sum(if[position_type = 2 and cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.amt_p_raise_made = 2.5 * cash_limit.amt_bb, 1, 0])

Where am I making a mistake?

[Flag_Hippo]

1. You shouldn't reference one column in another column so I would recommend using cash_hand_player_statistics.position (and number of players if necessary) instead of position_type. While you could use lookup_positions.flg_ep instead that wouldn't be cacheable.

2. You've not specified exactly how it isn't working for you but after creating new custom columns you should always rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

[ttesone]

1. You shouldn't reference one column in another column so I would recommend using cash_hand_player_statistics.position (and number of players if necessary) instead of position_type. While you could use lookup_positions.flg_ep instead that wouldn't be cacheable.

2. You've not specified exactly how it isn't working for you but after creating new custom columns you should always rebuild your custom database cache via 'Database -> Database Management -> Rebuild Cache -> Custom Cache Rebuild'.

1. Ok, will try using cash_hand_player_statistics.position, but how do I specify the number of players? For example, >=3 and <=6. Also, as I understand if, cash_hand_player_statistics.position goes from BTN = 0 to SB = 9. If it's a 6-max table, which number will EP be? Should I just make it like this: cash_hand_player_statistics.position between 7 and 5? And for MP cash_hand_player_statistics.position between 4 and 2?

2. It returns 0 cases which is impossible since 2.5bb open must be the most used RFI size. Didn't rebuild cache, will wait for your reply on 1 to do so and re-test

Thanks!

edit: would something like this do the work? This would be for RFI on EP in a 6-max table with more than 2 players

sum(if[(cash_hand_player_statistics.position = 3) and (cash_hand_summary.cnt_players between 3 and 6) and cash_hand_player_statistics.flg_p_open_opp and cash_hand_player_statistics.flg_p_first_raise and cash_hand_player_statistics.amt_p_raise_made = 2 * cash_limit.amt_bb, 1, 0])

[ttesone]

You can close this thread, the help you gave me plus some testing was more than enough to make it work. Thanks!