Aggregate component issue

Question

I'm using Aggregate in my package but i could not find the opinion to sum the data.

I could only see group by and count.

Advice pls！

Answer 1

Hi @L Tune,

Only columns with numeric data types can be summed. For more information, see SUM (Transact-SQL).

Please have a double check of your data type.

See Aggregate Transformation

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.