raise first in size

[mkjmkjmkj]

i would like make a stat raise first in size in BB one for 2bb 2-3bb 3bb 3-4bb 4bb and 4bb+
i have made it for tournement stats but i could not figure out how to do it in the cashgame section

[WhiteRider]

Did you try converting the stat from tournament to cash? If you select your tournament version and click the "Convert To" button (set the appropriate new game type there first) it should convert it for you automatically.

If you do need to build it manually in most cases if you use database fields beginning with tourney_holdem_ you can just remove the "tourney_" part to get the cash equivalent. If you click the blue "insert" link on the stat editor you can browse to select the appropriate database fields.
If you're still struggling please post the column expressions here and we'll help you out.

[mkjmkjmkj]

i have tried to convert it but there are some of coulumns that cant be used in the cash section

[kraada]

If you paste one of the expressions I'll be happy to tell you how to convert it.

[mkjmkjmkj]

(cnt_p_raise_3_4_first_in / cnt_p_raise_first_in) * 100

cnt_p_raise_3_4_first_in=
sum( if[tourney_holdem_hand_player_detail.amt_p_raise_made> 3*tourney_holdem_blinds.amt_bb and tourney_holdem_hand_player_detail.amt_p_raise_made<= 4*tourney_holdem_blinds.amt_bb and tourney_holdem_hand_player_statistics.flg_p_open_opp , 1 , 0 ] )

cnt_p_raise_first_in=
sum( if[tourney_holdem_hand_player_statistics.flg_p_first_raise AND tourney_holdem_hand_player_statistics.flg_p_open_opp, 1, 0])

when i try to convert it i get a message with expression not valid
but it is valid in the tournement section

[kraada]

The issue is the blinds amount - on the cash side it's holdem_limit.amt_bb - if you remove that piece and convert it then add that piece back in with the proper area that might be easiest (change 3* tourney_holdem_blinds.amt_bb to 3, then convert, then add back in * holdem_limit.amt_bb).