Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me to get Yes on third row when all the condition are true. Now I am getting No in all 3 rows.
I am not able to attach the app.
Please find the backend script
Table1:
Load * Inline [
ID,StartDate,End Date,Prod,Indication, Style
145863,05/01/2019,08/12/2019, Mobile,A,
145863,05/01/2019,08/12/2019, Mobile,B,
145863,05/01/2019,08/12/2019, Mobile,C,Compact
];
Front end expression:
if( Trim(Prod)= 'Mobile' and Indication='C' and Style = 'Compact 'and ( Year(StartDate) - Year([End Date]))<=3,'Yes','No')
Thanks in advance.
Try this
If(Trim(Prod) = 'Mobile' and Indication = 'C' and Style = 'Compact' and (Year(StartDate) - Year([End Date])) <= 3,
'Yes',
'No')
Try this
If(Trim(Prod) = 'Mobile' and Indication = 'C' and Style = 'Compact' and (Year(StartDate) - Year([End Date])) <= 3,
'Yes',
'No')