7 Replies Latest reply on Oct 13, 2017 2:46 PM by Shinichiro Murakami

    Define category

    Alex Gonzalez

      Good morning

       

      I would like to classify orders on three categories:

      Maintennce only

      Repair only

      Maintenance + Repair

       

      I am using the next formulas

       

      Categories:

      1. Maintenance:

      { FIXED [Num Orden]:MAX(IF [Desc Actividad] = 'MABLD' THEN 1

      ELSEIF [Desc Actividad] = 'D0138' THEN 1

      ELSEIF [Desc Actividad] = 'MAASG' THEN 1

      ELSEIF [Desc Actividad] = 'MADHD' THEN 1

      ELSEIF [Desc Actividad] = 'MAASD' THEN 1

      ELSEIF [Desc Actividad] = 'MABLG' THEN 1

      ELSE 0 END)} = 1

       

      2. Repair:

      { FIXED [Num Orden]:MAX(IF [Desc Actividad] != 'MABLD' THEN 1

      ELSEIF [Desc Actividad] != 'D0138' THEN 1

      ELSEIF [Desc Actividad] != 'MAASG' THEN 1

      ELSEIF [Desc Actividad] != 'MADHD' THEN 1

      ELSEIF [Desc Actividad] != 'MAASD' THEN 1

      ELSEIF [Desc Actividad] != 'MABLG' THEN 1

      ELSE 0 END)} = 1

       

      The problem is that for maintenance, the true or false is good  but in repair it is not working good because all give me True (I attach an image),

      I need to count how many Maintenance, Repairs and Maintenance+Repair I have, but i dont know wich is my mistake

       

      I attach worbook

       

      Sample.png