3 Replies Latest reply on Oct 3, 2018 9:13 AM by meenu choudhary

    Cannot mix aggregate and non-aggregate

    Ashleigh Hart

      Does anyone know how to fix this formula to remove the 'Cannot mix aggregate and non-aggregate..."

       

      IF [Store Type] = "Department Store"

      THEN ([Store Score]/32)

      ELSE ([Store Score]/44)

      END

       

      where store score is a sum of the score and 32 and 44 are total number of scoring opportunities respectively.

       

      Thanks