Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 increm...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    Try this in a new custom column:

    { [#"Min G/L Account No."]..[#"Max G/L Account No."] }

     

    Note the curly braces.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

Try this in a new custom column:

{ [#"Min G/L Account No."]..[#"Max G/L Account No."] }

 

Note the curly braces.

 

Pete

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That worked perfectly - thanks, Pete!