Sum function requires a list of numeric inputs

[db09]

 please help me

[scott192]

An obvious question, but is [Quantity] on your Product Purchase table one of a Number, Decimal or Price type?

[db09]

a text

[scott192]

Well....can you give an example of data that is stored in the column?  The SUM function requires the data to be numeric.

[Casmir]

If you are using the SUM() functions,  it requires a LIST of values e.g , 1,2,3. So when using SUM(), use like this SUM(LIST(...yourcolumns)). Yoir columns are separated with commas, which make them a list or an array.