4 Replies Latest reply on Nov 17, 2016 2:05 PM by Rekha Kesavan

    Help with MAX(IIF) Calculation

    Paul Ozule

      Please can someone tell me what i'm doing wrong with this calculation?

       

      MAX(IIF([Primary Member Type Description] = "Basic", 1,0) ELSEIF ([Line Status Code] = "C", 1,0))=1

       

      The first argument ("Basic") works: MAX(IIF([Primary Member Type Description] = "Basic", 1,0))=1

       

      but i'm trying to add a new argument "status code" and get this message "Expected closing parenthesis or comma while parsing argument list for MAX.

       

      Thank you.