Sum() behaviour

[Anonymous]

Hi,

does it make a difference perfomancewise?

sum(Value*ExchangeRate)

sum(Value)*ExchangeRate

You could assume that the second one is faster because its first sums all value and then multiplies it only once with the exchange rate.

But i dont know if thats the case in the QIX Engine.

Any thoughts are appreciated!

-Phil

[sunny_talwar]

Not sure about the performance, but second one would only work if you have a single possible ExchangeRate for each of the combination of your dimension. If there are multiple Exchange Rates, it will become null

[Anonymous]

Hello Sunny,

Im aware of that, thanks!