Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hello Sunny,
Im aware of that, thanks!