I am new in IBM Cognos Analytics 11.1.7, I am trying to add a new row but the code below is not working.
Expression Definition:
IF ([Date] >= _add_days(current_date,-7)) THEN ( 'YES' ) ELSE ( 'NO' )
If Date is older than 7 days then NO
Date column was created by casting a YYYY-MM-DD 00:00:00:00. row