M range stat help - PFR

[chris5555]

I'm trying to build a M-range stat for PFR but PT3 says "The statement is not valid SQL" when I create the new column. I looked at the M-range tutorial and added the code with an "and" per the example, but maybe in the wrong place?

First tried to build a custom column 'cnt_p_raise_bz' from the original PFR stat:

sum(tourney_holdem_hand_player_statistics.cnt_p_raise)


Then I copied & inserted the code for the blue M range:

sum(tourney_holdem_hand_player_statistics.cnt_p_raise and (tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) > 50))

Also tried adding at the end, but no luck. Seemed like it should be good, since it's just a qualifier added on to the existing code. (?)

sum(tourney_holdem_hand_player_statistics.cnt_p_raise) and (tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) > 50)

"The statement is not valid SQL" GRRR!

The VPIP stat was so straightforward, if someone can point me in the right direction, I would appreciate it. Thank you in advance!

Chris

[kraada]

You forgot the if[] portion of the stat, and a couple of other things. Changes in bold below:

sum(if[tourney_holdem_hand_player_statistics.cnt_p_raise > 0 and (tourney_holdem_hand_player_detail.amt_before / ( tourney_holdem_blinds.amt_bb + tourney_holdem_blinds.amt_sb + (tourney_holdem_hand_summary.cnt_players * tourney_holdem_hand_player_detail.amt_ante)) > 50), 1, 0])