Page 1 of 1

Limp and holds AA

PostPosted: Sun Jan 11, 2009 8:16 pm
by Messaa
Hello, I'm trying to create a stat which counts the number of times a player limped and was holding AA. The definition below doesn't seem to work, what is wrong?

sum(if[holdem_hand_player_statistics.flg_p_limp AND lookup_from_id(id_holecard, 'cardpair') = 'AA', 1, 0])

Re: Limp and holds AA

PostPosted: Mon Jan 12, 2009 6:14 am
by WhiteRider
I think this is because you can't use look_from_id in columns, only in Statistics.
This works:
sum( if[ holdem_hand_player_statistics.flg_p_limp AND holdem_hand_player_statistics.id_holecard=1, 1, 0 ] )

See this post for card values.