11 Replies Latest reply on Jul 20, 2018 2:40 PM by jon rios

    how to change calculation to work in CASE statement

    jon rios

      i have a multiple CASE WHEN THEN statement, i added another WHEN THEN, i get an error "cannot mix aggregate & non-aggregate comparisons or results in CASE"

       

      if i remove the SUM, the division doesnt work... what can i do to this formula to make it work with CASE STATEMENT?