2 Replies Latest reply on Jun 28, 2018 5:00 AM by Pak Hang Leung

    Start indexing after a certain condition

    Pak Hang  Leung

      Hi all


      Now I have a workbook with past sales data and future predicted data, and I would like to do the indexing for the future months.

      The definition is, when there is no actual sales figure, that means it's a future month. For the next month then it is 1, the month after will be 2 ... etc


      However, when I use the index function with condition i.e if baseline = 0 then index()  end, the index still starts from the first row regardless of the condition.

      When I use window_sum to add each time 1 to previous value, the order is actually in reverse i.e the ranking is in descending order.


      What is the error and how can I start assigning the index with a certain condition? Many thanks for your help!