F Cbet in pos and out of pos

[RafaBrewer]

how can I make a stat to know the percentages of Flop Cbet in position and Flop Cbet out of position. thanks

[WhiteRider]

If this is for use in the Hud then you don't need to make separate stats for in and out of position - you can add the Flop CBet stat to the Hud twice and then set the 'Has Position' property to in position for one and out of position for the other.

In reports it's probably easiest to do this with a filter.

If you do still feel that you need to make a custom stat for it then you can test for being out of position vs the flop bettor using this:

char_length(cash_hand_summary.str_aggressors_f) >=1 and cash_hand_player_statistics.position > substring(cash_hand_summary.str_aggressors_f from 1 for 1)::int

If you play tournaments replace 'cash_' with 'tourney_' throughout.
For more information on the 'aggressors' string see this thread.