Multiply by the value for a given day

[jacek27031]

Hi,
I have 3 datasets with fields:
1) (sale)
- [Customer ID]
- [Customer Name]
- [% Product ID]
- [% Date] YYYY-MM-DD
- [# Sales Out Quantity]

2) (Exchange rate)
- [% Date] YYYY-MM-DD
- [E/R] e.g. 1.14

3) (Price list)
- [% Product ID]
- [C-price]

Matching by date and product id. I need to create a measure and multiply
[# Sales Out Quantity] * [C-price] * [E/R] at the specific exchange rate [E/R] for a given day?

In other words, the day's sales must be calculated by the day's exchange rate. 

Thank you for any help!

[chaorenzhu]

Is there any issue when just using [# Sales Out Quantity] * [C-price] * [E/R] ? If your [% Product ID] and [% Date] are associated correctly between the tables, it should give you the correct result