3 Replies Latest reply: Oct 10, 2017 2:54 PM by Satish Kamath RSS

    Previous month value does not evaluating

    Satish Kamath

      Hi All

       

      I have report as under

       

        MY      Sep-2016    Oct-2016     Nov-2016

      Score

      S1             3                 5                  2

      S2             5                 3                  3

       

      The requirement is

        MY      Sep-2016    Oct-2016     Nov-2016

      Score

      S1             3                 Up                  Dn

      S2             5                 Dn                  NC

       

      I have used           

      if(max(RAG) -
      Max({$<MY={$(=chr(39) & date(AddMonths(MY, -1), 'MMM-YYYY') & chr(39))}>} RAG) > 0, '▲',
      if(max(RAG) -
      max({$<My={$(=chr(39) & date(AddMonths(MY, -1), 'MMM-YYYY') & chr(39))}>} RAG) < 0, '▼'
      , ''))

       

      Please advise

      Thanks