total sum calculation - Partial sum syntax

Sun, 26 May 2013 21:39:41 GMT

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.

Best,

Bradley

Re: total sum calculation sum syntax

swuehl — Sun, 26 May 2013 22:03:12 GMT

Have you tried something like

[Total Complaints] /

sum( TOTAL aggr(if([Item number]<>MainArticle ,' ',Sum ( InvoiceQty)),[Item number]))