7 Replies Latest reply: Apr 19, 2018 12:09 PM by kiran ch RSS

    No of months Count

    kiran ch

      Hi all,

      I am struggling with a small requirement, attached a small piece of data, in that there are two yellow back grounded columns which need to be calculated.

       

      every project has a start month and end month, I want two new columns like number of months, avg Savings

      for eg:

       

      Project ID, StartMonth, EndMonth,Savings, countofmonths,Avgsavings

      101,            Jan 17     ,  Apr 17     , 4000    ,  4                     , 1000

       

      count of months is derived as Jan, Feb ,Mar, Apr(count) and AvgSavings as Savings/Countofmonths ie 4000/4 = 1000


      Hope I am clear