Highlighted
Previous Contributor

Circulation reference

Unlike Excel, circulation reference is recognized based on Line item. Is there any solutions to resolve this problem?

2 REPLIES 2
Highlighted
Previous Contributor

RE: Circulation reference

Hi Eujin Can you please give more details into the error you are facing? Because, in general, Anaplan would error out when there is a circular reference in the lineitem formula. Regards Hari
Highlighted
Previous Contributor

RE: Circulation reference

Hello! Thank you. When I'd like to calculate actual ratio and forecast ratio by using statistics, I faced circulation reference problem. For Example, There is 3 line item. * Line Item 1. payment(a) : actual data only 2. Gross earned premium(b) : actual data only 3. payment ratio((a)/(b)) : actual and forecast 4. switching date : 2016-5-1 5. Current period : Apr 2016 * Condition  1. Actual Period - Jan 2013 ~ Apr 2016 / Forecast Period - May 2016 ~ Dec 2020 2. forecast figure of payment ratio is average of actual payment ratio between Jan 2015 to Apr 2016 Under this condition, For payment ratio line item, I want to use like this. IF START() < switching date then payment ratio((a)/(b)) else timesum(payment ratio((a)/(b)),-15,0,Average) However this logic is not possible in ANAPLAN. Therefore I solve this problem to add line item like below. 1. payment(a) : actual data only 2. Gross earned premium(b) : actual data only 3. payment ratio((a)/(b)- actual) : actual 4. payment ratio((a)/(b)- actual and forecast) : actual and forecast However IF there is more simple way to solve this problem, I'd like to try it. Because For Using ANAPLAN, I have to set up lots of logics so Adding line item method looks complex. My explanation is not unclear, please let me know. Thank you. Regards, Eunjin