Saturday, February 2, 2019

Get the average monthly Consolidated Average Rate for a specific fiscal year.

1. Navigate to Lists > Search > Saved Searches > New.

2. Selected Consolidated Exchange Rates on the list.

3. Under Criteria tab, set Period as a filter and select a specific fiscal year.

4. Under Results tab, make sure the following are added:


--From Subsidiary > Summary Type = Group

--To Subsidiary > Summary Type = Group


--Formula (Numeric) > Summary Type = Sum > Formula = {averagerate}/12

5. Assign a specific search name.

6. Hit Save & Run.

No comments:

Post a Comment