Range Sum Expression Help.

[bnelson111]

I have a Straight Table as below.

As you can see the WIP is a sum from ODBC table against the Pcodea and i'm attempting to have a range sum of it down dating against the new order qty (which is the customers orders). Problem is it continues to down date against a different Pcodea. As you can see it continues when Pcodea changes from 230325380 to 230325432. Code Below.

Any ideas?

[bnelson111]

Hopefully to have a share. file is send.qvd

let me know if you have received, never loaded file before..

[bnelson111]

Might have it.

([Jobline for Customer Aisling;.OutstandingQty])-rangesum(above(TOTAL(SUM({<[Pcodea]>}[new_order_qty])),0,NoOfRows(TOTAL)))

[bnelson111]

No its continuing on different pcodea ......

[bnelson111]

Thankyou for all your help very much appreciated, just got it. Rebuilt the chart and the expression was fine.

Again thankyou.  

sum([Jobline for Customer Aisling;.OutstandingQty])+sum([Inventory Stock For Customer Report Aisling;.InventoryQty]))
-rangesum(above(sum({<[Pcodea]>}[new_order_qty]),0,NoOfRows(TOTAL)))