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.