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?

[MK_QSL]

Try this

Aggr(Your expression, Pcodea)

UPDATE :

Try this..

SUM([Your Jobline Field] -RangeSum(Above(SUM({<CODE>}OrderQTY),0,RowNo(TOTAL)))

Change your fieldname accordingly...

[bnelson111]

Using the Aggr(Your expression, Pcodea) i get the following.

Using the SUM([Your Jobline Field] -RangeSum(Above(SUM({<CODE>}OrderQTY),0,RowNo(TOTAL)))

the table opens all Pcodea's

[MK_QSL · Accepted solution]

Use my second option

SUM([Your Jobline Field] -RangeSum(Above(SUM({<CODE>}OrderQTY),0,RowNo(TOTAL)))

[bnelson111]

Brilliant. Thanks

[bnelson111]

Just messed it up??

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

As you can see the row two balance should read 27600..

[MK_QSL]

Can you load your sample file?

[bnelson111]

Manish I'm using a personnal version. It's got a lot of other tables on different tabs. Would it help if I take screen shot of dim and expressions ? Sorry.

[MK_QSL]

You can always save the another version on your file and delete unwanted tabs.

Sometimes it is difficult to give you result without checking apps as above is working in my file...

[bnelson111]

Will do. Send in 15mins. Someone is using my pc. Thanks.