RFI by stacksize

[nherrego]

I build a custom stat for Raise first in for 75 to 1000 bb deep and only includes opens 2x to 4x but it is not working:
it shows values bigger then 100

(cnt_p_raise_first_in_75 / cnt_p_open_opp_75 ) * 100

cnt_p_raise_first_in_75 :
sum(if[(tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp) and ((tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)between 2 and 4)) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000 ) and true) , 1, 0])

cnt_p_open_opp_75 :
sum(if[(tourney_hand_player_statistics.flg_p_open_opp ) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000) and true)), 1, 0])

[Flag_Hippo]

cnt_p_raise_first_in_75 :
sum(if[(tourney_hand_player_statistics.flg_p_first_raise AND tourney_hand_player_statistics.flg_p_open_opp) and ((tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)between 2 and 4)) and ((((tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) >= 75 AND (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) <= 1000 ) and true) , 1, 0])

You have two mismatched brackets (highlighted in red) in the actions column so try removing those. FYI you can copy expressions into Notepad++ which highlights matching brackets automatically.

[nherrego]

it still shows a value that is bigger then 100 after deleting those

[Flag_Hippo]

Please attach your stat to a Support Ticket so we can take a look at that for you.

[potamito]

...custom stat for Raise first in for 75 to 1000 bb deep and only includes opens 2x to 4x...

I made this, try it....

Action Column

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_open_opp and  tourney_hand_player_statistics.flg_p_first_raise and (tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb) BETWEEN 2 and 4  and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 75 and 1000 , 1, 0])

Opportunity Column

Code: Select all

sum(if[tourney_hand_player_statistics.flg_p_open_opp and (tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb) BETWEEN 2 and 4  and (tourney_hand_player_statistics.amt_p_effective_stack / tourney_blinds.amt_bb) BETWEEN 75 and 1000 , 1, 0])

[WhiteRider]

it still shows a value that is bigger then 100 after deleting those

Did you rebuild the custom cache after you made your change? If not, your cache will still have the old values.
To do that go to Database > Database Management and click Rebuild Cache > Custom Cache Rebuild.

[nherrego]

I did rebuild the cache. I will try potamito hes stat after the weekend. thnx

[nherrego]

The action stat from potamita shows invalid sql when i try to save it

[WhiteRider]

There's a typo there. This:
(tourney_hand_player_statistics.amt_p_raise_made / tourney_limit.amt_bb)
..should be this:
(tourney_hand_player_statistics.amt_p_raise_made / tourney_blinds.amt_bb)
..in both columns.