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

# help needed with 2 calculation fields

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

• ###### 1. Re: help needed with 2 calculation fields

Hi,

Is that what you wanted?

workbook attached for your reference. Let us know if this help.

Mahfooj

1 of 1 people found this helpful
• ###### 2. Re: help needed with 2 calculation fields

Yes thank you so much

• ###### 3. Re: help needed with 2 calculation fields

You're welcome Imran