Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below requirement.
I have used the below condition to get the output in below table but not getting correctly. I am getting all No in 3 rows.
Please help me on this.
Load
ID,
Start Date,
End Date ,
Prod ,
Indication,
Style ,
if( Trim(Prod)= 'Mobile' and Indication='C' and Style = 'Compact ' and ( Year([ Start Date]) - Year([End Date]))<=3,'Yes','No') as Output
From …
ID Start Date End Date Prod Indication Style Output
145863 05/01/2019 08/12/2019 Mobile A - No
145863 05/01/2019 08/12/2019 Mobile B - No
145863 05/01/2019 08/12/2019 Mobile C Compact Yes
Could you please help me on above issue.