nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error In Formula - how to understand Circular Reference

Jsdeloria21

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,

Circular_Reference_53292.docx

Accepted answers

hari.prasad

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

All comments

usman.zia

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

dmitrii.mamaev

Hi,

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

Will it help?

hari.prasad

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

Quick Links

Can you help?

Unanswered questions

ADO, TR VIEW Concatenation
I am working with Anaplan Data Orchestrator (ADO) and trying to transform uploaded data by adding a new column and concatenating several columns to create a unique key. However, some cells in these columns are empty. When this happens, ADO returns the entire concatenated key as NULL instead of using the values available in…
Multi-Cell Selection for Calculation Summary
Multi-Cell Selection for Calculation Summary When selecting two or more cells in Anaplan, a calculation menu appears in the bottom-right corner displaying useful statistics such as Count, Min, Max, Average, and Sum. This is a helpful functionality for quickly analyzing selected values. However, the current functionality is…
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…