New_Date is less compared to Current selected Old_Date

[bhargavikn]

Hello,

Need an expression for the query.

IF

New_Date is less than 5 Months compared to Current selected Old_Date, it should show N/A

Else

Sum(Sales).

Please help me with expression.

Thanks in Advance.

[bharathadde]

Try this

=if(New_Date<AddMonths(Old_Date,-5),'N/A',Sum(Sales))