Forum Discussion
Solved
Simple Divide Filter
Hello,
I have a table
COL_a ...... COL_b ....... COL_c ....... COL_d
I need to divide COL_a with COL_b (That is a simple messure),
but I only need to divide COL_a with COL_b when COL_c value is XX and COL_d value in not YY
Can you please help?
Hi,
You can handle is with new column with this formula
=IF(AND(Table1[COL_c]=XX,Table1[COL_d]<>YYY),Table1[COL_a]/Table1[COL_b],0).
Hasan
1 Reply
Hi,
You can handle is with new column with this formula
=IF(AND(Table1[COL_c]=XX,Table1[COL_d]<>YYY),Table1[COL_a]/Table1[COL_b],0).
Hasan