VPIP depending on increasing BB, tell me where the error occ

[egorzar]

VPIP depending on increasing BB, tell me where the error occurred.

In PokerTracker stats for their use in the SNG does not take into account the growth of BB because of this benefit is so basic stats (VPIP and PRF) comnitelna, but there is an opportunity to write their articles.

Here's my attempt rializovat this opportunity to VPIP depending on> BB

VP $ IP = (cnt_vpip / cnt_hands) * 100

cnt_vpip = sum (if [tourney_holdem_hand_player_statistics.flg_vpip, 1, 0])

cnt_hands = sum (if [tourney_holdem_hand_player_statistics.id_hand> 0, 1, 0])


As I understand the need (in the form of uposchennom), add dependency> BB, for example
the early stage of BB <100

BB values are: live_table_stat ('amt_bb')> 100

Now when trying to create a column:

cnt_vp1 = sum (if [tourney_holdem_hand_player_statistics.flg_vpip AND live_table_stat ('amt_bb')> 100, 1, 0])

and column:

cnt_h1 = sum (if [tourney_holdem_hand_player_statistics.id_hand> 0 AND live_table_stat ('amt_bb')> 100, 1, 0])

Getting error "The statement is not valid SQL"

[kraada]

The live stats are only for statistics which display on the table right now based on the player's stats from last hand.

You want to use:

(holdem_hand_player_detail.amt_before / holdem_limit.amt_bb) > 100 (or < 100 or whichever) and that will do what you want to do.