How to refer a properties in formulas

Hi, How can we refer properties in formula

Accepted answers

All comments

Hi Pavan!

Can you be a little more specific as to what you might be looking for? Are you looking for how the formula was created? Do you want to understand the formula used in a specific area of your model?

So information here maybe helpful: https://community.anaplan.com/anapedia/model-building/formula-editing

Thanks!
Emily

PrevContributor

Hi Emily,
I have created a module with few line items
e.g. A - Format List
       B
       C
i want to refer one of A's property to populate the value for B on selection of a specific list value from A

e.g.
List Values      Property value
1                            X
2                            X
3                            V
4                            Z

so when 1 is selected in A the value of B should come as X
This is what iam trying

Thanks.

peter_mcanena

You need to say

B = List.Property[LOOKUP: A]

where List is the name of your list and Property is the name of the property you want to get.

Livy@acn

@peter_mcanena hi~

B = List.Property[LOOKUP: A]

the A, means a item in a LineItem of the List, is that right?

thank you~

Quick Links

Can you help?

Unanswered questions

How to calculate the weight?...
Hi all I have a list of networks organized hierarchically on a list of entities, which is itself organized hierarchically on a list of divisions (organization). An entity can have several networks. I also have a list of product models, which is itself ranked with three higher levels: this “Models” L4 list is ranked at a…
Forecaster Explainability Results Clarification
We transitioned from PlanIQ to Forecaster and started importing explainability results into the model. But I’m struggling to interpret some of the since there is no information in Anapedia. Here are examples from the sales explainability results list: Historical: trend (ETS, ENSEMBLE) Historical: linear_trend (ENSEMBLE,…
ADO connection problem with “Google Cloud Storage”
I’m having a problem connecting to “Google Cloud Storage” with Anaplan Data Orchestrator. The GSP Service Account Email is correct and the GCP Private Key is correct, but it will not accept the bucket name. Please provide some guidance. Thanks.