Update Exchange Rates template

Objective

Use the recommendations in this template to update exchange rates and review impact to country price lists.

Example flow

Edit data

1. Open the Manage Exchange Rates scenario workbook.
   When you created the scenario, this workbook was loaded with data from base and decision support workbooks.
2. Open the Update Exchange Rates worksheet.
3. In the New Rate column, update rate values. Update values manually or upsert data from a CSV file.
4. Update values in the Start Date column.

CASE 
    WHEN COALESCE ({New Rate}, 0) = 0 THEN NULL 
    ELSE ({New Rate} - {Current Rate) / {Current Rate} 
END

5. Open the Review Country List Prices worksheet to review the New Country List value, which shows how the new rate affects country list prices.

The following information shows how other columns, column groups, and KPI cards in this worksheet are calculated. Use this information for additional decision support.

New Country List

{List Price} * {New Rate}

Price Change

CASE 
    WHEN COALESCE ({Country List}, 0) = 0 THEN NULL 
    ELSE ({New Country List} - {Country List}) / {Country List} 
END

Publish data

1. In the Update Exchange Rates worksheet, select the Publish checkbox for records that represent updated and final data. This information will be published back to the base and master data workbooks.
2. From the Actions menu, select Publish.

The selected records are synchronized with the Exchange Rates waterfall element workbook.