Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

List.generate Issues

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'...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago

    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.  

AlienSx's avatar
AlienSx
Super User
2 years ago

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.