Forum Discussion
Trouble with List.Generate
I have two whole number columns, "Min G/L Account No." and "Max G/L Account No.". I'm trying to create a new, calculated column which contains a list of each whole number between those two (in increments of 1). To do this, I'm using the following query in the Custom Column dialog:
List.Generate(
() => ([#"Min G/L Account No."]),
each _ <= ([#"Max G/L Account No."]),
each _ + 1
)
It accepts the formula, but each field in the newly created list column contains the following error:
Expression.Error: We cannot apply field access to the type Number.
Details:
Value=10020 (NOTE: this value changes per row)
Key=Max G/L Account No.
I've confirmed I can create a list of numbers by just changing the values in the formula to hard coded numbers, but cannot figure out what I'm doing wrong with the formula that is resulting in the error.
Any help would be much appreciated! Thank you in advance!
Hi Anonymous ,
Try this in a new custom column:
{ [#"Min G/L Account No."]..[#"Max G/L Account No."] }Note the curly braces.
Pete
2 Replies
- BA_PeteSuper User
Hi Anonymous ,
Try this in a new custom column:
{ [#"Min G/L Account No."]..[#"Max G/L Account No."] }Note the curly braces.
Pete
- AnonymousNot applicable
That worked perfectly - thanks, Pete!