stat formulation

[raph156]

Hi,
Whats wrong?
sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%') ,if [ (holdem_hand_player_statistics.id_holecard = 26) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%') , 1, 0]])
Thanks for help

[raph156]

i tryed thise too
sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.enum_p_3bet_action='C' , if[ (holdem_hand_player_statistics.id_holecard = 26) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.enum_p_3bet_action='C' ,1, 0]])

[kraada]

A few things:

(1) You can't use "if [" it has to be "if[".
(2) You didn't have an else clause for the first if[] statement.

This validates:

sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%'), if[ (holdem_hand_player_statistics.id_holecard = 26) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%') , 1, 0] , 0])

You also might want to add parentheses around your OR statements to make sure they group the way that you intend as (A AND B) OR C is not the same as A AND (B OR C).

[raph156]

Thise one is valide, that work too?
sum( if[ (holdem_hand_player_statistics.id_holecard = 1) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%'),1 , if[(holdem_hand_player_statistics.id_holecard = 26) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%') ,1, 0]])
Thanks for help

[kraada]

Yes, though as I look at it you can simplify considerably.

This will do the same thing and is much easier to comprehend:

sum( if[ (holdem_hand_player_statistics.id_holecard = 1 OR holdem_hand_player_statistics.id_holecard = 26) AND holdem_hand_player_detail.amt_p_raise_made>0 OR holdem_hand_player_statistics.flg_p_face_raise AND (lookup_actions_p.action SIMILAR TO '(C|XC)%') OR (lookup_actions_p.action SIMILAR TO '(R|XR)%'), 1 , 0])