Forum Discussion

Sudheeshp's avatar
Sudheeshp
Frequent Visitor
3 years ago

Group Table based on a numeric column converted to Text column

Please help me, in my table Trx ID which is numberic; I have converted into text and when i group basedon this, the error message is as follows:

 

DataFormat.Error: We couldn't convert to Number.
Details:
Trx ID

 

Table.Group(#"Removed Columns2", {"Trx ID"}, {{"Sum", each List.Sum([Gross]), type nullable number}})

Need Help

1 Reply

  • ronrsnfld's avatar
    ronrsnfld
    Super User
    3 years ago

    Is the Table.Group step the very first step where that error appears?  Or does it appear on preceding steps also? If the latter, where is the first step when that appears?