1 Reply Latest reply: May 26, 2013 6:03 PM by Stefan Wühl RSS

    total sum calculation - Partial sum syntax

    Bradley Coyne

      hi i would like to do the following.


      i have two expressions which i need to work out a percentage for.


      Swuehl has a helpful answer however i wish to accomplish partial sum calculation as described in Problem.jpg.


      Expression 1:Total Complaints  - >sum(if(left([Item number],1)<8,(ComplaintQty*PartComplaintFlag),0))

      Second expression


      Expression 2. Invoice Qty ->sum(aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))


      much help is appreciated in this respect.