3 Replies Latest reply on Oct 9, 2018 4:57 AM by Mahfooj Khan

    help needed with 2 calculation fields

    Imran Azam

      HI Guys

       

      i have created a worksheet showing results of new/repeat and lapsed contracts which looks like the below

       

      Status
      Fy2015
      fy 2016
      FY 2017fy2018
      fy 2019
      new211
      repeat221
      lapsed121

       

      I  have two tasks i am stuck one

       

      1)  i am trying to create a calculation field that, would calculate only the new and repeat for each FY. eg it should look like the below

       

      Status
      Fy2015
      fy 2016
      FY 2017fy2018
      fy 2019
      new211
      repeat221
      lapsed121
      Calculation 123310

       

       

      2) I also need to produce a calculation field which would  show the percentage of business repeat rate , the logic to this would be take curent FY repeat number and divide this by previous year calculation 1 result, e.g fy2016 repeat / fy2015 calculation 1 in this case 2/2 = 100% it should look something like below

       

      Status
      Fy2015
      fy 2016
      FY 2017fy2018
      fy 2019
      new211
      repeat221
      lapsed121
      Calculation 123310
      Calculation 2100%    66.67%33.33%0.00%

       

       

      can this be done , if so how and whats is  the best way to do this?

       

      i have attached the work sheet to the post

       

      i will be grateful for any help

       

      thank you