Power Query working standalone, but not in function

[gvg]

Hi,

I have this function that calculates column total and places it on every row. It works OK if it is placed in the stand-alone query, but it fails when placed into a function.

= Table.AddColumn(#"Removed Columns", "Inv sum", each List.Sum ( #"Removed Columns"[#"Q-ty"] ))

I end up with this error message: "Expression.Error: We cannot apply operator - to types Text and Text."

How do I go around this?

[gvg · Accepted solution]

Well, it turns out that one has to be careful with column format definition. If you have column in general format, it adds up ok in stand-alone query, but fails if the query is organized as a function. When I define column as Decimal or Integer it all works as expected both in stand-alone query and function.

[v-piga-msft]

Hi @gvg,

It seems that you have solved your problem, please accept the your replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best Regards,

Cherry