Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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