Difference using Sum()

[Anonymous]

Hello,

I was wondering if there's any difference between Sum(Price * Quantity) and Sum(Price) * Sum(Quantity). If there is any difference, when should I use each?

Thanks!

[#2]

The first is sumproduct in my oppinion. So it adds the multipled results.

[swuehl]

Try this:

LOAD * INLINE [

Price, Quantity

1, -1

2, 0

3, 1

];

Do you see a difference? Why?