Column to count how often a player faced a limp

[erdnase17]

I know there is already a column for this cnt_p_facing_limpers but I didn't notice at first so I tried to make my own (for HU tables) like so:

sum(if[tourney_hand_player_statistics.amt_p_raise_facing = 0 and lookup_actions_p.action LIKE '_' and tourney_hand_player_statistics.position = 8, 1, 0])

but I get a different count. What is missing here?

[kraada]

How far off are the counts?

[erdnase17]

Over the biggest sample size (my own) it counts 2440 while cnt_p_facing_limpers counts 2474.
It seems like my version undercounts this stat. Any thoughts?

Thanks.

[kraada]

You're undercounting because you're looking for exactly one action - 34 times you raised and were reraised and thus took a second action, which would filter you out of the expression you put together.

[erdnase17]

You're undercounting because you're looking for exactly one action - 34 times you raised and were reraised and thus took a second action, which would filter you out of the expression you put together.

Thanks. I guess if I would remove lookup_actions_p.action LIKE '_' it would return the same value then.

[kraada]

You could make it lookup_actions_p.action LIKE '_%' - that means you had at least one action but maybe more.