Simple Divide Filter

[sabeensp]

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?

[hasanarslan · Accepted solution]

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