How to calculate within the list items to get the maximun of the items from the first to current?

Hi everybody!

Need help to do the calcution within the list.

Here is a list with items(#1,#2,#3,...), and properties of Input and Output.

The Output is supposed to be the maximun value of the input from #1 to the current item as below table.

Anyone has solutions about this? I found it difficult to calculate list item dynamically.

Name	Input	Output	※How to calculate the Output
#1	25	25	=MAX(#1:#1)
#2	20	25	=MAX(#1:#2)
#3	30	30	=MAX(#1:#3)
#4	10	30	=MAX(#1:#4)
#5	40	40	=MAX(#1:#5)
#6	30	40	=MAX(#1:#6)
#7	20	40	=MAX(#1:#7)
#8	25	40	=MAX(#1:#8)
#9	10	40	=MAX(#1:#9)

Accepted answers

All comments

rob_marshall

@CeciliaRen

This looks fun...Let me ask you this, how many list members are you talking about, the 1-9 in your example?

CeciliaRen

#1~9 is just an example.^^
Actually the list have about 500,000 members and parent of about 100,000 members, e.g. 1 parent with 1~20 children.
And the calculation just need to do within the members under the same parent, as the example above you could image that the #1~9 have the same parent.
Please let me know if you need any further explanation on this.

rob_marshall

@CeciliaRen

And you just want the Max number at the parent level? Have you looked into the summary method of Max?

CeciliaRen

I want the max value of the member which is within #1~current as example above which is used to adjust the input value.

CeciliaRen

@rob_marshall

Thank you for kindly reply.

Here is another example.

If the List item have values like,

10, 15, 5, 20, 10, 30, 20, 25, 5

Then the results I want is,

10, 15, 15, 20, 20, 30, 30, 25, 5

These list items have the same parent but summary is no need and the calculation only has to be done on the child level.

Best regards!

rob_marshall

@CeciliaRen

Can you do me/us a favor and show use a true sample of the List member as well as the code? Is Time or Period part of it?

Rob

CeciliaRen

@rob_marshall

Thank you for your reply!

We are still confirming the feasibility of this requirement.

Here is the test module (no time dimension), 'org' is input data, 'tobe' is what we want to calculate, and others are my tentative calculations, you can ignore them.

best regards,

Cecilia Ren

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
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…