Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Nope, not a job for set analysis. Use an if statement.
If((Col1 >= Addmonths(Today(),-6) and Col2 = 'Complete') or Col2 = 'Active', Col3)
Any help on this please?
Nope, not a job for set analysis. Use an if statement.
If((Col1 >= Addmonths(Today(),-6) and Col2 = 'Complete') or Col2 = 'Active', Col3)
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.