Why does this code fail?
Acknowledge that the "Amounts" column is intentionally of type text. I can use List.Sum and Number.From in conjunction with say Table.AddColumn, and all works out as you would expect. The numeral of type text is converted to a numeral of type number, and the summation is done.
However, when I use List.Sum and Number.From in conjunction with Table.Group, this code fails:
= Table.Group(
#"Changed Type",
{"Name"},
{
{"Amount", each Text.Combine([Amounts], "/"), type nullable text},
{"Total Amount", each List.Sum({Number.From([Amounts])}), type nullable number}
}
)
Amountsas shown, thenTable.AddColumn(....., each List.Sum(Number.From([Amounts]))will return an error, contrary to what you write. (I suspect what you wrote is incorrect).Number.Frommust have only a single value for it's argument. Within yourTable.Groupfunction,[Amounts]represents a List of all the entries in the Amounts column of the grouped table. In theTable.AddColumnfunction, it will only represent the single value on the same row. The solution by @hansraj should work for you.