Hi Everyone ,
I'm trying to figure out the forumla to calculate the weighted average if Contract# from table 1 = Contract # from table 2 & Invoice Date from Table 1 = Date from Table 2.
anyone can help??
<tbody>
</tbody>
<tbody>
</tbody>
I'm trying to figure out the forumla to calculate the weighted average if Contract# from table 1 = Contract # from table 2 & Invoice Date from Table 1 = Date from Table 2.
anyone can help??
Table1 | |||
Cotract# | Invoice Date | Volume | Price |
Con01 | 20-Mar-13 | 1000 | 1.5 |
Con01 | 20-Mar-13 | 1000 | 1.5 |
Con01 | 20-Mar-13 | 1000 | 1.5 |
Contract02 | 23-Mar-13 | 500 | 1 |
Contract02 | 23-Mar-13 | 600 | 2 |
Contract02 | 19-Mar-13 | 700 | 3 |
Contract02 | 23-Mar-13 | 800 | 4 |
Contract02 | 23-Mar-13 | 900 | 5 |
Cot03 | 01-Mar-13 | 1000 | 1.3 |
Cot03 | 01-Mar-13 | 1000 | 1.3 |
Cot03 | 01-Mar-13 | 1000 | 1.3 |
<tbody>
</tbody>
Table 2 | ||
Weighted Average Price when contract # and Date matche Table 1 | ||
Cotract# | Date | |
Contract02 | 23/03/2013 | ???? |
Expected Answer 3.36 | ||
<tbody>
</tbody>