No resulte for a stats

[raph156]

Hi,
I would like, % of time a player fold on the flop when facing bet > 50 % of the pot when 4>pot >9
I created thise, expressions valids but there is no numbers.

Stat
( ffbf_opp49 ) * 100 / ( fbf_opp49 )

Columns
ffbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct > 50 AND holdem_hand_summary.amt_pot BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_p.action SIMILAR TO '(F|XF)%'), 1, 0])

fbf_opp49
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct > 50 AND holdem_hand_summary.amt_pot BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) , 1, 0])

Thanks for Help

[kraada]

amt_pot_f is the total amount of the final pot - the PT3 database schema does not store the amount of the pot on the flop (PT4's will, however).

[raph156]

Thats change everithings. I search an other solution.

[raph156]

The things i can do is:
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_p.action SIMILAR TO '(F|XF)%'), 1, 0])
Do i have number of time facing bet between 4 and 9 and fold?
But thise information is not so good than what i would like.
That count when the pot is between 4 and 9 or when between 51 and 100. That dont tell the same thing of a player. But i ll do that during find a solution or have PT4.

[kraada]

val_f_bet_facing_pct is the percentage of the pot of the bet you faced.

So if the bet was 5 into a pot of 10 and you face it you have to call 5 to win 15 so val_f_bet_facing_pct is 33.33

If you want the absolute value of the bet you want amt_f_bet_facing.

[raph156]

I want to be sur i understand.
>val_f_bet_facing_pct is the percentage of the pot of the bet you faced.
The final pot, not the pot on flop?
For exemple, if the pot on flop is 9bb, and the final pot of the hand is 30bb. That ll calcul the percentage of the final pot of the bet on the flop im faced?
Thanks for help.

[kraada]

No that one is based on the pot size on the flop - just the actual pot size on the flop is not stored.

You can infer it back if someone does make a flop bet, but if they don't, you won't know the size of the pot on the flop.

[raph156]

So i dont understand whats wrong in my first post, cause that count number of time a player fold on the flop when facing bet > 50 % of the pot when 4>pot >9 and number of time a player on the flop facing a bet > 50 % of the pot when 4>pot >9.
In the twice events that count only if there is a bet so the size of the pot on the flop can be know.

[raph156]

May be, i understand now, i have to make an expression which count nb time bet between 4 and 9 and bet >50% of the pot. Cause bet >50% of the pot work but amount of the pot not.
So that make
sum( if[holdem_hand_player_detail.val_f_bet_facing_pct > 50 and holdem_hand_player_detail.amt_f_bet_facing BETWEEN ( 4*holdem_limit.amt_bb) AND ( 9*holdem_limit.amt_bb) AND (lookup_actions_p.action SIMILAR TO '(F|XF)%'), 1, 0])

[kraada]

That will work and give you all times someone overbet the pot.

(Why an overbet? If the pot starts at 1 and someone bets 1.25 it's now a 2.25 pot and you have 1.25 to call - more than half the pot. it's exactly half when they bet the full pot as 1+1 = 2.)