Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I short question. Where is exactly the differnce between for example
if( One > Two, Count(Nr), Null())
and
count(if( One > Two, Nr, NUll())) ?
Thanks...
Hi,
the first one calculates One > Two onece and returns the count of Nr or Null
and the second one calculates One > Two for every row and returns the count of Nr where One > Two.
Regards
Sebastian Lettner
Short answer is here: Sum(if(...)) vs If(Sum(...), Sum(...))
The first one will give you a count of the field Nr where one is greater than two
The second will will return the field value of Nr where one is greater than two