Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Let's say I have an expression like this:
SUM(
Pick($(vSelectorValue),
Aggr(Sales),
Aggr(Orders),
Aggr(Shipments)
)
The idea is to SUM one of the Aggr values based on the variable value of vSelectorValue.
Is the above expression an efficient way to write? Is there a better way to write the expression to make it efficient?
Of course I am aware that Aggr can be performance impacting but my question is around the above expression.
Why do you need Aggr() here? Is Sales, Order, and Shipments expressions or fields? If they are fields, why don't you just do this
Sum(Pick($(vSelectorValue), Sales, Orders, Shipments))
Hi Sunny,
It's because I am presenting a simplified version for the question.
In reality my Aggr is a bit more complex and contains variables etc inside.
Without seeing the real thing, it might be difficult to suggest ideas for improvement...