List.generate Issues

[Anonymous]

Hi Experts,

I am having an issue with the below code, It lays around the : result = List.Generate(
() => [runningTotal, additionalValuesList, 0],  I get a error message stating that i need a token']' but can not find a issue here.

Any help as always would be greatly appreciated 

Kind Regards

RunningTotal     AdditionalValues

4	0
-6	0
-16	4
-19	10
-21	6
-35	3

let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
AddValues = Table.AddColumn(Source, "AdjustedRunningTotal", each
let
runningTotal = [RunningTotal],
additionalValuesList = List.Buffer(Table.Column(Source, "AdditionalValues")),
result = List.Generate(
() => [runningTotal, additionalValuesList, 0],
each List.First(_) < 0,
each [
List.First(_) + List.First(List.Middle(_)),
List.RemoveFirstN(List.Middle(_), 1),
List.Last(List.Middle(_)) + List.First(List.Middle(_))
]
)
in
List.First(result)
)
in
AddValues

[AlienSx · Accepted solution]

Hi, @Anonymous [runningTotal, additionalValuesList, 0] is record, record has fields, fields have names. Your record does not have field names. 

Next, each List.First(_) < 0 evaluates each item in the list that List.Generate generates. But wait, the very first item is record, not list.

And finally, even if you fix all bugs in your code then List.First(result) is going to give you ... the very first item which is your record defined in the very first line of List.Generate. 

You'd better explain here how would you like the column AdjustedRunningTotal to be calculated.