5 Replies Latest reply: Jun 10, 2016 1:54 PM by Sunny Talwar RSS

    Ignoring specific data while summing

    Troy Strachan

      Hey guys, thanks in advance for any help and/or advice.

       

      I am trying to sum our sales data, where some items are not included in the overall tracked sales because it is raw material.

       

      Below is some dummy data. So what I am asking is how do I ignore "Part D" in the summation of the items sold. What I want is for that totaled number to be 14 NOT 15.

       

      The hitch, is that I still want the item to still be displayed, otherwise I would just define a restriction in the Load statement.

       

      ITEM     ITEM NUM      QUANTITY     PRICE     TOTAL

      Part A     123               1                    1.00          1.00

      Part B     456               2                    2.00          4.00

      Part C     789               3                    3.00          9.00

      Part D     122               4                    0.25          1.00

                                                                             15.00