You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Calculate Average Exchange rate in FCCS

in Financial Consolidation and Close 3 comments

Summary:

Is there any way to calculate Average Exchange rate input value through a calculation logic(average of Cumulative Ending Exchange rate)

Content (please ensure you mask any confidential information):

Client is expecting to calculate Average Exchange rate automatically in FCCS using the calculation logic(average of Cumulative Ending Exchange rate), Example: Period1 Ending FX rate is 1.45 and Period2 Ending FX rate is 1.50, so average exchange rate for Period2 should be (1.45+1.50)/2 = 1.475, Average rate should 1.475 for Period2, for Period3 it should be Ending rate of (P1+P2+P3)/3. Unfortunately we don't have a option to write Business rule/rule or member formula in Rate cube(its grade out). Please let me know if there is any other option to calculate Average Exchange rate in FCCS.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!