Re: FX CalculationsApril 24 2012 at 2:49 PM
No score for this post
from IP address 188.8.131.52
Response to NONEMPTYMEMBER in ASO within CASE Statements
This sounds like you are computing the gains and losses on changes in currency exchange rates and you are sometimes using eom values and somtimes mid month values. Right?
My first two questions are is this calc in the accounts dimension? And is the accounts dimension a dynamic or a stored hierarchy. If your answer is not that it is prinicpally a stored hierarchy that will be the key to your fix.
Reply with the answers and the hierarchy.
Is this by any chance a daily database?
- Re: FX Calculations - Anonymous on Apr 24, 2012, 4:39 PM
- Fx usually means ... - Danp on Apr 24, 2012, 6:44 PM
- Fx usually means ... - Anonymous on Apr 25, 2012, 4:50 AM
- YTD should not be formula - DanP on Apr 26, 2012, 1:02 PM