circular reference error with no time dimension used.

Highlighted
Frequent Contributor

Re: circular reference error with no time dimension used.

Hi @DouglasEaton,

 

Thanks for the below help.

I tried the below solution, but I still get the circular reference error while trying to refer the previous line item value from Test module2 to test module1.

 

not sure If I am missing anything here..

screenshot1.JPGscreenshot2.JPGscreenshot3.JPG

 

Thanks & Regards,

Madhu

Highlighted
Certified Master Anaplanner

Re: circular reference error with no time dimension used.

Hi Madhu,

Without having a proper look at it it's a bit hard to tell. In theory it should work just fine.

I wonder if it doesn't have something to do with your formula for "Interest accretion at rate b/f - UPR" as it also references the first two line items.

Maybe try replacing that one by a input only and see if it solves the circular. If so we'll have to focus on that line item. 

Cheers

Highlighted
Frequent Contributor

Re: circular reference error with no time dimension used.

Hi @Douglas Eaton,

 

You are right, the formula for 'Interest accretion at rate b/f - UPR' also refers to the first two line items.

The line item are very much dependent on each other, your provided solution works fine when I create a test module and replicate the same solution as you provided in screenshot but not sure where it is breaking in case of my module.

 

I believe updating the line item by creating a temporary line item to hold the value and then populating the final by a process would be the best way in such scenario.

I was just trying to avoid to trigger a manual

 

Thanks & Regards,

Madhu

Highlighted
Certified Master Anaplanner

Re: circular reference error with no time dimension used.

if you give me the exact formula for  'Interest accretion at rate b/f - UPR' I can have another go at it.

Did you try removing the formula and putting in my fix?

Highlighted
Frequent Contributor

Re: circular reference error with no time dimension used.

Hi @DouglasEaton 

 

In first screenshot LM1 values populated in blue is what I need i,e prior cell value of Final rate.

Screenshot1.JPGSC2.JPGsc3.JPG

Highlighted
Certified Master Anaplanner

Re: circular reference error with no time dimension used.

Ok so I tested it and the problem comes from the formula in your "interest accretion" line item.
The easiest way to solve it is to do all of your calculation against real time (any time periods will do, you just need to be able to use the PREVIOUS() function), map those to your fake time periods and bring the values back. s
It should be fairly straight forward.
Hope it solves it
Highlighted
Certified Master Anaplanner

Re: circular reference error with no time dimension used.

Hello Madhu,

 

Try to check summary method. I often catch bugs "reference error" caused by summary.

Hope it can help.

 

Dmitrii. 

Highlighted
Frequent Contributor

Re: circular reference error with no time dimension used.

Hi @dmitrii. mamaev ,

 

Thank you...I did checked the summary method, they are all set to Sum.

 

which should be fine I believe.

 

Thanks & Regards,

Madhu