column stops working after just *0.7 operation in it

Discuss how to create custom stats, reports and HUD profiles and share your creations.

Moderators: WhiteRider, kraada, Flag_Hippo, morny

column stops working after just *0.7 operation in it

Postby Leopard » Sun Apr 10, 2022 7:51 am

sum(if[ (cash_hand_player_statistics.amt_t_effective_stack - cash_hand_player_statistics.amt_t_bet_made - cash_hand_player_statistics.amt_t_raise_made) - 0.7*( cash_hand_summary.amt_pot_t + 2*(cash_hand_player_statistics.amt_t_bet_made + cash_hand_player_statistics.amt_t_raise_made)) < 0 AND (cash_hand_player_statistics.cnt_t_raise > 0 or cash_hand_player_statistics.flg_t_bet) AND cash_hand_player_statistics.cnt_t_call = 0, 1, 0])

NOT working!

but if I delete *0.7 it works again!

Idea of column: how many times opponent do such stupid stake on Turn, when gets to River with SPR < 0.7
Leopard
 
Posts: 18
Joined: Tue Mar 26, 2013 2:58 pm

Re: column stops working after just *0.7 operation in it

Postby Flag_Hippo » Mon Apr 11, 2022 6:39 am

If you want to test for an SPR of < .7 on the river then you should do that like this:

Code: Select all
(cash_hand_player_statistics.amt_r_effective_stack / cash_hand_summary.amt_pot_r) < .7
Flag_Hippo
Moderator
 
Posts: 12200
Joined: Tue Jan 31, 2012 7:50 am

Re: column stops working after just *0.7 operation in it

Postby Leopard » Mon Apr 11, 2022 9:25 am

okay, 2 quastions:
1) is it principle to write .7 or 0.7 ?

2) my formula concerns not only cases when guys go to River. But also those, when defender folds Turn to overbig stake (but if he calls --> SPR river --> will go to <0.7)
Leopard
 
Posts: 18
Joined: Tue Mar 26, 2013 2:58 pm

Re: column stops working after just *0.7 operation in it

Postby Flag_Hippo » Mon Apr 11, 2022 11:35 am

1) It doesn't matter.

2) In addition to the expression you've posted can you also please provide a written definiton of exactly what situation you want to be counted in your custom column.
Flag_Hippo
Moderator
 
Posts: 12200
Joined: Tue Jan 31, 2012 7:50 am


Return to Custom Stats, Reports and HUD Profiles

Who is online

Users browsing this forum: Google [Bot], stakkedoff and 6 guests

cron
highfalutin