3 Replies Latest reply on Sep 14, 2018 5:39 AM by Anders Bonfils

    Calculated field - Renaming date on one worksheet does not work on another worksheet with similar setup

    Anders Bonfils

      Hi Guys,

       

      I made a calculated field that renames the date (1. april 2018 to Q2).

       

      This is possible on one worksheet but not on another.

       

      STR( CASE MONTH([Date (Monthly Demographics (Danske Bank-Koncernen))] )

      WHEN 1 THEN "Q1"

      WHEN 2 THEN "February"

      WHEN 3 THEN "March"

      WHEN 4 THEN "Q2"

      WHEN 5 THEN "May"

      WHEN 6 THEN "June"

      WHEN 7 THEN "Q3"

      WHEN 8 THEN "August"

      WHEN 9 THEN "September"

      WHEN 10 THEN "Q4"

      WHEN 11 THEN "November"

      ELSE "December" End)

       

      Setup 1.JPG

       

      Setup 2.JPG

       

       

      Any help ?

       

      Thanks