11 Replies Latest reply on Jan 9, 2019 3:08 AM by Jonathan Drummey

    Display the client id where the flag('Y') is available since more then 5 months from selected months.

    kavi ram

      Hi Team, Lei Chen Jonathan Drummey

      I would like to display the output for the following points,

      1) The clients where Watch list Flag(as 'Y') data since more than 5(>=) months from the month selected.

      2) The clients where Watch list Flag(as 'Y') and downgraded to Default Flag (as 'Y') after 3 months and 6 months.

       

      Below is the sample data like,

      Watch list flag data:

      Default Flag data:

      The output for the questions would be:

      1) Based on the month selection Nov 2018, output should be only 'client 4' this meets the condition since more then 5 months as 'Y'.

      2) Based on the month selection Aug 2018, output should be only 'client 8' this meets the condition after 3 months (Default flag as 'Y' in Nov 2018)

          Based on the month selection July 2018,  output should be only 'client 9' this meets the condition after 6 months (Default flag as 'Y' in July 2018)

       

      Please find attached the workbook for the reference .

      Thanks in Advance,

      Kind Regards,

      Kavi