Subreport, subtract from sum

[J33]

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?

 

[lbass]

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

-LB

 

[hilfy]

To clarify what @lbass said, your formulas should look like this:

{@SP10}
if {so.stockplace} = 10 then {so.shipped}

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

-Dell

Senior Manager, Data & Analytics
Protiviti

http://www.protiviti.com