Gonzalo Perez Farina

Updated December 22, 2021 14:36

SUM(CASE ...) statement

Follow

Hello!

When C9QL gets across a 

SUM(CASE WHEN condition THEN 1 ELSE 0 END) AS test_column

It throws an error. Is there a solution to this? Am I doing something wrong? 

• 

  Brigham Berry December 22, 2021 18:08

  Hi Gonzalo,

  I believe the issue here is that you cant do aggregations on a field in the same step it was created. Remove the sum in this step, add a step, and then take the sum and it should work.

   

  0

  Comment actions Permalink
• 

  Gonzalo Perez Farina December 22, 2021 19:32

  Hey Brig!

  Yes, that's how I've worked around it :) wanted to see if there was a way of doing it in the one step. No problem!

  Thanks

  0

  Comment actions Permalink

Please sign in to leave a comment.