Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm a newbie for QV.
Hope you guys clearify
What is the difference btw. Sum(If(condition, amount, ...)) and If(condition, Sum(amount), ...) ?
I don't know how to explain, but may be an example might help you understand how they are different.
I have attached an example where there are two cases when the outputs of the two will match and then places where they won't match.
I am pretty sure that the second expression will never work in a text box object (unless you have used an Aggr() function) because there is no dimension in a text box object.
Note: Second and third expressions are essentially almost same
HTH
Best,
Sunny
See here: Re: Sum(if(...)) vs If(Sum(...), Sum(...))
- Marcus