4 Replies Latest reply: Nov 11, 2015 2:22 PM by Michael Reagan RSS

    Calculated Expression Label in Excel Report?

    Michael Reagan

      Hello all -

       

      I have a straight table that has expressions for the column labels. The table shows a rolling 13 weeks.

      Capture.PNG

      The expression that builds the column labels is:

      =Date(Only({1<Cal.RelativeWeek = {'-13'}>} Cal.WeekStartMon),'MMM-DD')

       

      When I add the columns from the table to the Template editor and preview the report, the column headers come through as the text of the expression rather than the result.

      Capture2.PNG

      How do I get the column labels to calculate?

       

      Thanks!

       

      mike