Good day!

I need help to solve the following problem.
There are two forms for data collection:
1. Weighing packaging.
2. Gross weighing.
Common feature of forms is the invoice number.

What is the best way to combine the information collected on these forms in 
one table? 

And calculate:
NET = GROSS - TARE.

For example:

I have:

Invoice           GROSS                                 Invoice       TARE
101                     1000                                  120           
  150
120                      2000                and             101           
  200
130                      3000                                  130         
    300 

I need:

Invoice      GROSS    TARE     NET
101             1000        200        800
120              2000       150         1850
130              3000       300         2700



Thank you in advance.

-- 
You received this message because you are subscribed to the Google Groups 
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/groups/opt_out.

Reply via email to