Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subreport, subtract from sum

Status
Not open for further replies.

J33

IS-IT--Management
Apr 8, 2019
14
FI
Hi,

I have a subreport that is calculating the sum of shipped items per item code (from sales order rows) that belongs to a project number and a bill of materials. Now I need the subreport to take the stock places in consideration and subtract from the "shipped items sum" the rows that have been shipped from stock place 10. How can I do that?

1. I get the project number via parameter fields and our ERP is giving the information on which item codes to show
2. I have a normal summary calculating the shipped items right now, and it is adding all shipped items
3. The result is grouped by item code in the main report and also in the subreport

I have tried with:
sum({so.shipped}) - {@SP10}

in the SP10 formula field I had the following:
if {so.stockplace} = 10 then sum({so.shipped}) <- is that even possible?



 
Remove the sum() from your formula and then insert a sum on the formula.

-LB
 
To clarify what @lbass said, your formulas should look like this:
Code:
{@SP10}
if {so.stockplace} = 10 then {so.shipped}

{@Shipped Items}
sum({so.shipped}) - sum({@SP10})

-Dell

Senior Manager, Data & Analytics
Protiviti
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top