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]



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


      Could someone plase assist.


      Thank you,