Highlighted
Contributor

Error In Formula - how to understand Circular Reference

Hi,


Please see details on the attachment. My apologies for not posting it on the message box I document my inquiries on my pc for future references.

 

Regards,

3 REPLIES 3
Community Boss

Re: Error In Formula - how to understand Circular Reference

 Hi @Jsdeloria21 

 

This is not the solution to exact problem but a way you could approach it:

 

To approach this type of issue what I do is break the formula I want up into segments.

Then I try to write the formula with part of the statement removed to see if I get the circular reference error.

Then keep iterating until you find the part which causes the error.

This then helps you to identify where the error is coming from. 

 

Then you can focusing on understanding the statement which causes the circular ref. 

 

I hope this helps,

 

Thanks,

 

Usman

Certified Master Anaplanner

Re: Error In Formula - how to understand Circular Reference

Hi,

Try to add Subset "Phase No1" (contain only 1 phase) as a dimension of sourse module.

Will it help?

Occasional Contributor

Re: Error In Formula - how to understand Circular Reference

Are you able to resolve the circular reference issue, that you have reported ?