Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
The first is sumproduct in my oppinion. So it adds the multipled results.
Try this:
LOAD * INLINE [
Price, Quantity
1, -1
2, 0
3, 1
];
Do you see a difference? Why?