Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
the following expressions give the same result:
- If(Condition, Sum({<Set Analysis>}Dimension_1), Sum({<Set Analysis>}Dimension_2))
- Sum({<Set Analysis>} If(Condition, Dimension_1,Dimension_2))
I want to say if there is a difference in terms of optimization? What is the fastest expression?
Thank You
Hi
check this link
"When is it best to use sum(if()) over Set Analysis in an expression?"
There is also a small Optimization manual.
for better performance use flags in the script and set analysis in the expressions
Best
Felipe
Hi,
what if you handle "if" statement in your set analysis part?
I think in this case you'll have the fastest way.
Hi
check this link
"When is it best to use sum(if()) over Set Analysis in an expression?"
There is also a small Optimization manual.
for better performance use flags in the script and set analysis in the expressions
Best
Felipe
Thank you 🙂