If condition in set analysis

[Anonymous]

I have an expression like below , basically i want all Active values in Col2 and Complete values in Col2 for Past 6 months , when these 2 conditions are satisfied i want to get values in Col3 , Can someone please help me put this in set analysis

If( Col1 >= Addmonths(Today()-6) and Col2 = ' Complete' and Col2 = 'Active', Col3 )

Thank you!

[Anonymous]

Any help on this please?

[Gysbert_Wassenaar · Accepted solution]

Nope, not a job for set analysis. Use an if statement.

If((Col1 >= Addmonths(Today(),-6) and Col2 = 'Complete') or Col2 = 'Active', Col3)

[Anonymous]

oh .. is the above if statement right ? i am not sure how to define all Active values and only Complete values for past 6 months.