5 Replies Latest reply on Oct 18, 2016 1:09 PM by nataraj.vijayanagaram

    Pick Data from Prev Month if Data for current month is Blank

    nataraj.vijayanagaram

      Hello,

       

      I have a Table which has actuals that gets refreshed automatically.

       

      MonthValue
      January23
      February24
      March20
      April22
      May25
      June23
      July24
      August25
      September26
      October
      November
      December

       

      Is it possible to create a calculated field which will fill the empty (NULL) values for all the months to the latest month Data (Example - Fill Oct, Nov & Dec with 26). I have another table with the month where I have pipeline as 1,2 & 2 for Oct, Nov & Dec. If the calculated filed can take the prev month data I can then add with the second table to show a trend. Please advise.

       

      Thank you for your support.

       

      Nataraj