2 Replies Latest reply on Feb 29, 2016 3:28 PM by Mikey Michaels

    Fix Date Calculated field

    Mikey Michaels

      Hello All,

      I'm having trouble linking my parameter "Quarter Year" with my "Date" dimension.

       

      I have created a calculated field called 'Highlight Quarter" which should highlight the year and quarter when it is selected using my "Quarter Year" parameter. The problem is my "Highlight Quarter" calculated field is incorrect. instead of highlight the entire year, I instead want to highlight just the quarter and year.

      Quarter_Year.png

       

       

       

       

       

       

       

       

       

       

       

      My "highlight quarter" calculated field reads year([Date]) == year([Quarter Year]). How do I adjust this so my calculated fields highlights just the quarter and the year?

       

      Thanks for all your time,

      Andrew