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...
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
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