Skip to Content
0
Former Member
Dec 01, 2008 at 10:55 AM

select query problem

12 Views

hi all,

im creating a report in which there is the prob like ,

matnr qty mtype

123 10 101

123 -5 122

123 -5 122

123 10 101

123 -5 122

here im ding the sum of qty of mtype 122 but here i dont want last 122 (-5) to be added there else my total will get change like,

10 -15 = -5

but i want it like

10 - 5 = 5 - 5 = 0 +10 - 5 = 5.

plz help me out

thanx...