3 Replies Latest reply on Dec 13, 2016 12:26 AM by Andrew Watson

    Pick last three months from Maximum date

    shlpa deshmukh

      Hi Guys,

       

      Can someone help me on this. I have one date column. i want to color the line chart using date in such a way that (maximum date - 90) should be colored in one color and rest in other.

       

      I am using this calculation but its not working.

       

      IF (ATTR([Date])=[Max Date]

      or ATTR([Date])>=DATEADD('day',-90,[Max Date]))

      THEN 'Forecast' else 'Actual' END

       

      Please correct me. Looking for help asap.

       

      Thanks