Hi,
Can someone please help me with this:
I have a table with these columns:
<tbody>
</tbody>
I have another table with the monthly exchanges rates:
<tbody>
</tbody>
How can I get in an efficient way the Total 2016 in CAD?
Thanks,
Edu
Can someone please help me with this:
I have a table with these columns:
Product | Original currency | Jan-16 | Feb-16 | ... | Dec-16 | Total 2016 in original currency | Total 2016 in CAD |
A | USD | 3 | 5 | 8 | XX | (3*1.3)+(5*1.28)+...+(8*1.294) | |
C | EUR | 3.4 | 3.2 | 1 | XXX | (3.4*1.4)+(3.2*1.42)+(1*1.5) |
<tbody>
</tbody>
I have another table with the monthly exchanges rates:
Jan-16 | Feb-16 | ... | Dec-16 | |
USD | 1.3 | 1.28 | 1.294 | |
EUR | 1.4 | 1.42 | 1.5 | |
CAD | 1 | 1 | 1 |
<tbody>
</tbody>
How can I get in an efficient way the Total 2016 in CAD?
Thanks,
Edu