Circular reference: SELECT function

Hello, I'm currently working on a module, where one of the Rate list items is a difference of the other two, indicated in bold. The problem that occurs here is that I receive a circular reference error, because I'm changing the line item 'Prepay (Partial)'. However it would never circular refer to itself, because of the IF Function. Is there a way to override this error or a better way to select the two numbers from the other Rate list items? IF ITEM(Rates) = Rates.Margin THEN 'Gemidd.Enc Previous YTD'[SELECT: Rates.Client Rate] - 'Gemidd.Enc Previous YTD'[SELECT: Rates.FTP] ELSE IF ITEM(Rates) = Rates.Margin Net of LP THEN 'Prepay (Partial)'[SELECT: Rates.Margin] - 'Prepay (Partial)'[SELECT: Rates.Liquidity Premium] ELSE 'Gemidd.Enc Previous YTD'

Accepted answers

harish_bk

Hi Mickel

Since you are trying to refer the same line item in the formula for which the formula is being written, even though you are using the select, try to plan them in different line items and then combine the values.

You just put an example in excel and share i can suggest you the method.

PrevContributor

Hi Harish,

Thank you, I was able to get the desired result by creating two proxy line items.

All comments

PrevContributor

So to summarize, I would like link one list item to two other list items, which are all in the same list Rates. Thus, Margin Net of LP = Margin - Liquidity Premium. Is this possible? I need them in the same list, so I can make a new table with all of them in the headers.

harish_bk

PrevContributor

Hi Harish,

Thank you, I was able to get the desired result by creating two proxy line items.

Quick Links

Can you help?

Unanswered questions

Sorting General List
Hi, I wonder if there's a way I can sort my general list alphabetically. The list is used as a drop down menu in a line item module and I want the drop down menu to be easy to navigate. I've already tried the Order List action. I already have a module with a text-formatted line item based on that list. But when I try to…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…