Newbie basic summary question

[Jimbojames30]

Hi all,

 

Sorry for this question, i have a table where it has Product Code, Lot number, Qty all i want to do is sum the quantity by Product code

 

product codes can have different lot number but i just want to the sum of each product code,

 

many thanks

 

 

 

[Tom R.]

Hi Jim,

 

In the same table where your product code field is, add a new summary field, perhaps named productCodeTotal__s ( "__s" for summary, likewise "__c" for calculation fields). Specify Total of, and select your quantity field. 

 

Then on any layout where you want to view the totals, you need to create a subsummary layout part, and specify ...when sorted by Product Code. You will need to add the productCodeTotal__s field to the new subsummary part you created. Then just sort your records based on the Product Code.

 

I hope this helps,

 

regards,

 

Tom