How to avoid Circular Reference
I am looking for a solution on how to write a formula that takes the value for 1 and Jan 21 and adds that value to the answer to the formula in cell 2 and Jan 21.
The formula I have currently is the below. What is in bold is what I need to figure out.
IF Financial Projection Time = Financial Projection Time.'1' THEN Sales Premium * Sales to Inforce Timing ELSE Sales Premium * Sales to Inforce Timing + the previous row value in that column
The 1-4 is representing a list of values from 1-256. They represent calendar months while the Jan-21, Feb 21 etc represent sales month.
Does anyone have any suggestions here? I get a circular reference each time I enter the line item name. I also tried to make a Previous Financial Projection time line item and enter that but I get a circular reference as well.