7 Replies Latest reply on Jan 23, 2018 12:09 AM by Niranjan Banarjee

    Unable to get the Table(Down) option

    Niranjan Banarjee



      I am trying to calculate Share in the below view, but its is not displaying the  compute using Table (Down) option..


      Rolling Forecast =


      CASE [Rolling Data Type]

      WHEN "MTD" THEN 0

      WHEN "R3M" THEN -2

      WHEN "R6M" THEN -5

      WHEN "R12M" THEN -11

      WHEN "YTD" THEN (-[YTD Indicator-CY]+1)


      , 0)


      Requirement= Rolling Forecast/Total(Rolling Forecast) , but it is also not allowing the following error erupts.