WP1 - For each month, we are taking average monthly rate which is aligned with BI4. Example: When looking at data of current month (say August), the exchange rate used is the July average month rate and for past months, the exchange rate used will be the selected month's average rate.
PF1 - for previous years', the full year's average rate is applied to the corresponding full year data from document currency to Euro and from document currency to USD. Current year, the conversion is based on the year to date average rate at (M-1) and applied to all months in current year including current month's data. (Please take special note on Example 1 & 2) *Example 1 (month): In current month (say August), the sales result in current year have applied the year to date exchange rate as of end July. Due to this, there will be slight differences when comparing the result in Analytics dashboard against BW report. *Example 2 (Quarter): Taking August as current month, and when selecting Q2 (April to June), the sales results applied the same exchange rate mechanism, the exchange rate taken in Analytics dashboard will be year to date exchange as of end July where in BW, the year to date exchange rate is as of end June, which again generates slight differences when comparing the two reports.
