3 Replies Latest reply on Jun 6, 2018 12:24 PM by Jim Dehner

    Creating New Variables Using if


      I want to create a new calculated field with if statement. EG:  I have a column name Type  If Type is Apple the it is '15' elseif type Mango then '20'

      max for apple is 15 and mangoes is 20

      IF [Type]="Apple" THEN'15'

      ELSEIF [Type]="Mango" THEN'20'


      where Type is a  string and other calculated field is a number

      i want to subtract it from other column(calculated) . it is showing error Cannot mix aggregate and non-aggregate arguments with this function" When Creating a Calculated Field