Re: Automatic colors statistics
Posted: Thu Aug 04, 2016 5:42 pm
Hello again.
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:
I also tried this:
And this:
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.
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.