Calculation within the list

Hi!

I've got a list with few properties.

I need to get calculations ("calculation" property in the file attached) baced on the the previous calculated value of the same item in the list.

Is there any way to do this. Maybe i should use module?

Thank you!

Mockup_68575.xlsx

Tags

Modeling

Calculation Functions

Accepted answers

ChrisAHeathcote

Using a mapping and LOOKUP function is the only approach that will allow you to reference a different item within the same list.

When setting up the items in your list use a number reference as your code.

In your system model recover the code for the current list item and convert to number from text.

Create a rule to subtract the number of list items you need to retrieve data from. In your case as it is the previous item subtract 1.

Use this result to FINDITEM of the corresponding list item. This will create the mapping you can use to retrieve data for any previous list item in that list.

Chris

All comments

First of all please create a SYS module for this list and avoid making any properties in the list

Second if you have to get the previous value of any list item try creating a lookup module and map the list items accordingly. And then use this module to pull the data of previous list item based on the mapping

Hope that helps

Misbah

P.S You can use PREVIOUS or Time Functions when there is no timescale

@Misbah , Shure i will use SYS module.

Iookup and mapping wil not do

I need to get recalculated previous value of the same property

Pleace see the mock up (Calculation property)

ChrisAHeathcote

Using a mapping and LOOKUP function is the only approach that will allow you to reference a different item within the same list.

When setting up the items in your list use a number reference as your code.

In your system model recover the code for the current list item and convert to number from text.

Create a rule to subtract the number of list items you need to retrieve data from. In your case as it is the previous item subtract 1.

Use this result to FINDITEM of the corresponding list item. This will create the mapping you can use to retrieve data for any previous list item in that list.

Chris

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
How to Design Simulation Planning in Anaplan with Multi-Level User Input and Step-by-Step Logging?
Hi Anaplan Community, I'm working on a simulation planning model where users need the flexibility to input pricing adjustments at any level of the product hierarchy, and I’d love your guidance on best practices. 📌 Scenario Overview: We have a 4-level product hierarchy: Brand Category Sub Category SKU (lowest level) The…