Accumulate the value of the previous record

[Juan_Francisco_]

In an activities table there is a name field and duration type. I need to accumulate the value of the duration of the previous record and of this new one in a field called accumulated duration

Help please

[Steve]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT() Tips & Tricks 💡

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), "My Table", "_ROWNUMBER", "Wanted Column" ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

[Juan_Francisco_]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

Thank you so much

[Juan_Francisco_ · Accepted solution]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

How do I get a column value from the last row of this thing only? LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) ), “My Table”, “_ROWNUMBER”, “Wanted Column” ) Replace My Table with the name of the table from which you want the column value; Thing with the name of the column containing a value that identifies the thing you want (e.g., Order ID); and Wanted Column with the name of the column whose value you want. See also: MAX()

Function ‘LOOKUP’ should have exactly four parameters: LOOKUP(lookupValue, tableName, lookupColumn, returnColumn)

[Juan_Francisco_]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) )

Apparently I am missing an argument, but I don’t know which one or where it goes. Could you help me

[SkrOYC]

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

SELECT( My Table[_ROWNUMBER]

^^^
Your expression looks way different from @Steve’s one

[Juan_Francisco_]

Hello. Thank you for meeting my request for help. This is the expression that Steve gives me as a solution to my problem.

LOOKUP( MAX( SELECT( My Table[_ROWNUMBER], ([_THISROW].[Thing] = [Thing]) ) )

When substituting for my fields I have

Steve mentions me “and Wanted Column with the name of the column whose value you want”

I understand that it is the missing parameter, but it did not tell me where it is put. Can you help me?

[Juan_Francisco_]

I got it.
Tks

[Juan_Francisco_]

Hi
I have this problem

[Steve]

Please post a screenshot of the entire expression.

See also:

help.appsheet.com

LOOKUP()

Get column value from row in table or slice

[Juan_Francisco_]

Steve:

Please post a screenshot of the entire expression.

that’s the whole expression

[Juan_Francisco_]

I need it to return the value of the [Duration] field. However, in the expression you sent me you did not put where it goes, you only wrote that it was the column that you wanted to receive

[Steve]

You aren’t using LOOKUP() correctly.

[Juan_Francisco_]

Correctly. This was you tell me.

[Juan_Francisco_]

I got it.
Thank you