Forum Discussion

gavin007's avatar
gavin007
Helper V
5 years ago
Solved

invalid identifier for list.sum syntax

Hi, I use group by window to sum Rev Act and GM Act by InvoiceDate and OrderNo_Revised_Item. it all works well until I try to amend the sum of Rev Act by applying a condition in when evaluating the s...
Need Help
  • ImkeF's avatar
    ImkeF
    5 years ago

    Hi gavin007 ,

    yes, I didn't pay attention to the other code. Problem is, that you have used the "each"-keyword twice and now the syntax sugar doesn't know what to refer to.

    Therefore I'd recommend to transform at least one of the functions to the explicit syntax:

     

    Table.Group(Source, {"InvoiceDate", "OrderNo_Revised_Item"}, {{"Ext Rev Act", each List.Sum(Table.SelectRows(Source, (row) => row[#"I/C"]="C") [Rev Act]), type nullable number}, {"GM Act", each List.Sum([GM Act]), type nullable number}})

     

ImkeF's avatar
ImkeF
Community Champion
5 years ago

Hi gavin007 ,

yes, I didn't pay attention to the other code. Problem is, that you have used the "each"-keyword twice and now the syntax sugar doesn't know what to refer to.

Therefore I'd recommend to transform at least one of the functions to the explicit syntax:

 

Table.Group(Source, {"InvoiceDate", "OrderNo_Revised_Item"}, {{"Ext Rev Act", each List.Sum(Table.SelectRows(Source, (row) => row[#"I/C"]="C") [Rev Act]), type nullable number}, {"GM Act", each List.Sum([GM Act]), type nullable number}})

 

gavin007's avatar
gavin007
Helper V
5 years ago

ImkeF That is awsome. It is working perfecly. Can i humbly ask how and where can i learn this syntax? I am good with click and drop but when it comes to scripting,  expecially with the M language structue, i find it difficult to write a script like that.