5 Replies Latest reply on Feb 6, 2019 1:06 PM by Ramesh N

    Changing field(dimension) values dynamically using parameters.

    Ramesh N

      Hi All,

       

      Please give your suggestions and ideas to get the following scenario.

       

      I have 2 dimensions & 2 parameters

      Dimension                   :     Values

      Category                     :     Actual, Budget, Forecast

      Year                             :     '2017', '2018', '2019', '2020', '2021'......

      Parameter                   :     Values

      Current_Quarter        :     'Jan', 'Apr', 'Jul', 'Oct'

      Current_Year              :     '2018', '2019', '2020'

       

      I have created the below 2 calculated fields  using the above dimensions & parameters.

      Calc_Category

      IF Current_Quarter = "Jan" THEN Category = "Actual" ELSEIF Current_Quarter = "Apr" THEN Category = "Budget" ELSE Category = "Forecast" END

      Calc_Prev_Year

      IF Current_Year = "2018" THEN Year = "2017" ELSEIF Current_Year = "2019" THEN Year = "2018" ELSEIF Current_Year = "2020" THEN Year = "2019" END

      Calc_Next_Year

      IF Current_Year = "2018" THEN Year = "2019" ELSEIF Current_Year = "2019" THEN Year = "2020" ELSEIF Current_Year = "2020" THEN Year = "2021" END

       

      I am getting an error in all these calculated_fields (Boolean <> String).

      Is there any other way to get this requirement done?

       

      Thanks in Advance,

      Ramesh