PokerTracker

For some reason I can't get the line: holdem_hand_player_detail.flg_f_has_position to work in my stats.

Here is my code:

Code: Select all

sum(if[cash_hand_player_statistics.position=8 AND
cash_hand_player_statistics.flg_p_first_raise AND
cash_hand_player_statistics.flg_p_4bet_opp, 1, 0])

So I'm in the BB, made the first raise and now have a chance to 4bet. This works, but I only want it in a BBvsSB situation.

I searched the forum and found a topic that suggested using: holdem_hand_player_detail.flg_f_has_position.

Now if I turn my code into:

Code: Select all

sum(if[cash_hand_player_statistics.position=8 AND
cash_hand_player_statistics.flg_p_first_raise AND
holdem_hand_player_detail.flg_f_has_position AND
cash_hand_player_statistics.flg_p_4bet_opp, 1, 0])

it says the statement is not valid SQL. Anyone knows what I'm doing wrong?

See my reply in your another post, IMO should be the same bug

Oh man, this is going to solve so many issues I had. Thanks and sorry for "polluting" the forums with what's essentially the same issue, I wasn't aware of this bug at all.

Happy to help man

<snip> mistake on my part.

In case someone else stumbles onto this: I made the mistake of using the wrong line:
holdem_hand_player_detail.flg_f_has_position
should be
cash_hand_player_statistics.flg_f_has_position