I've been trying several days testing based on trial and error but I cannot find the correct expression.
You says:
if( a AND b, 1, 0)
That expression is easy, but I have problems with the use of "AND" and "OR" in longer chains because it affects the anterior and posterior expression. For example, I want that displayed 1 if any of them conditions between parentheses is certain although the others are false, but is mixed them conditions:
if( a AND b, 1, 0) OR if( c AND d, 1, 0) OR if ( e AND f, 1, 0), 0), 0)
But 'OR' does not work with the "Nested IFs" so this expression is not valid:
- Code: Select all
if( (cnt_p_3bet_opp >10.00 AND cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.00 OR if( cnt_p_ccall_opp >10.00 AND cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60 OR if( cnt_f_cbet_def_opp >10.00 AND cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 1, 0), 0), 0)
I also tried this:
- Code: Select all
if( (cnt_p_3bet_opp >10.00 AND cnt_p_3bet / cnt_p_3bet_opp * 100 <=8.35) OR (cnt_p_ccall_opp >10.00 AND cnt_p_ccall / cnt_p_ccall_opp * 100 <=6.60) OR (cnt_f_cbet_def_opp >10.00 AND cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp * 100 >=46.42), 1, 0))
And this:
- Code: Select all
if( (cnt_p_3bet_opp >10.00 AND cnt_p_ccall_opp >10.00 AND cnt_f_cbet_def_opp >10.00 AND (cnt_p_3bet / cnt_p_3bet_opp) * 100 <=8.35 AND (cnt_p_ccall / cnt_p_ccall_opp) * 100 <=6.60 AND (cnt_f_cbet_def_action_fold / cnt_f_cbet_def_opp) * 100 >=46.42, 1, 0 ))
The problem is that "AND" and "OR" not listed conditions as I want, which are minimal opportunities with its corresponding statistics. They just do also missing one of the 3 conditions (excluding opportunities) is true the number value to display "1".
Thank you very much beforehand, is driving me crazy this confusion.