Aggregation help

[mahitham]

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.

[vvira1316]

Style = 'Compact '

There is a space aster t at the end of Compact

Style = 'Compact'

[sunny_talwar · Accepted solution]

Try this

If(Trim(Prod) = 'Mobile' and Indication = 'C' and Style = 'Compact' and (Year(StartDate) - Year([End Date])) <= 3,
'Yes',
'No')