3 Replies Latest reply on Dec 7, 2017 12:16 PM by arvindgarg

    Grouping based on percent or records

    Bianca Reddick

      I have 40,000 Work Orders that have roughly 50 problem types. Roughly 10 of these problem types make up 30,000 work orders. I am trying to group together the ones that make up less than 5% into an "Other" Catrgory

       

      IF {FIXED [Problem Type] : SUM([Number of Records]) / TOTAL (SUM([Number of Records]),.5}

      THEN "Other"

      ELSE [Problem Type]

      END

       

      This is returning an error "Level of detail expressions contain table calculations or the ATTR function"

       

      Could someone plase assist.

       

      Thank you,

       

      Bianca