Hi I have a question here
can line item fields be populated with item property values by selecting item member in a module?
@MaheshKosuri
yes, you can use SELECT but you would have to hard code the formula. I would suggest a different approach, one that uses the DISCO methodology. For me, I almost always create a SYSTEM module for every list I create, especially if know that list will have properties that I need to lookup. To create a SYSTEM module, create a new module using only the list in the "applies to". Time should be removed. In your planning module that may contain a variety of lists, you can use the LOOKUP function to obtain the property you want. So in your planning module it might look like this: Salary = SYS08 Employees.Salary[LOOKUP: SYS08.EMPLOYEE], where EMPLOYEE is a list formatted line item and SYS08 and your planning module both use the same list in the "applies to". Hope that helps.
Also, if you have a specific example you want to explore, post it here. Happy to create an example for you!
You got this!
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…
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.…
Estimated Level of Effort:4-8 Hours of Model Building Level of Difficulty: Beginner Recommended Training: L2 Model Builder Training Persona: Casual Model Builder Potential ROI: Decreased planning time Increased accuracy of targets/spreads You Might Also Like: * Historical Snapshotting Top-Down Allocations Whether it's…