Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=if(New_Date<AddMonths(Old_Date,-5),'N/A',Sum(Sales))