Error: Expression: Invalid number of functions

[DOMIATED89]

I'm making a custom column report and get a column error:

Error: Expression: Invalid number of functions passed to 'if' (Expecting 3, Returned 2).

Where is the issue:

Code: Select all

if[(cash_hand_player_statistics.flg_f_saw AND cash_hand_player_statistics.flg_f_has_position AND cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.flg_p_3bet)
AND NOT
(cash_hand_player_statistics.flg_p_4bet or cash_hand_player_statistics.flg_p_4bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_squeeze_def_opp)
, 1, if[(cash_hand_player_statistics.flg_f_saw AND NOT (cash_hand_player_statistics.flg_f_has_position) AND cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.flg_p_3bet)
AND NOT
(cash_hand_player_statistics.flg_p_4bet or cash_hand_player_statistics.flg_p_4bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_squeeze_def_opp)
, 2, if[(cash_hand_player_statistics.flg_f_saw AND cash_hand_player_statistics.flg_f_has_position AND cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.flg_p_3bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_4bet or cash_hand_player_statistics.flg_p_4bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_squeeze_def_opp)
, 3, if[(cash_hand_player_statistics.flg_f_saw AND NOT (cash_hand_player_statistics.flg_f_has_position) AND cash_hand_summary.cnt_players_f = 2 AND cash_hand_player_statistics.flg_p_3bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_4bet or cash_hand_player_statistics.flg_p_4bet_def_opp)
AND NOT
(cash_hand_player_statistics.flg_p_squeeze or cash_hand_player_statistics.flg_p_squeeze_def_opp)
, 4, 5]]]]

[Flag_Hippo]

What format expression are you using for the groupings in the custom statistic that is using this column?

[DOMIATED89]

What format expression are you using for the groupings in the custom statistic that is using this column?

Code: Select all

if(this = 1, format('Aggressor HU IP'), if(this = 2, format('Aggressor HU OOP'), if(this = 3, format('Defending HU IP'), if(this = 4, format('Defending HU OOP'), if(this = 5, format('Other')))))

[DOMIATED89]

Apparently, i'm not missing a ")" at the end.

[Flag_Hippo]

The expression needs a final ELSE condition. For example:

Code: Select all

if(this = 1, format('Aggressor HU IP'), if(this = 2, format('Aggressor HU OOP'), if(this = 3, format('Defending HU IP'), if(this = 4, format('Defending HU OOP'), format('Other')))))