I am trying to apply a rate using an [END] - [AVG] currency formula. My app is a YTDINPUT but I don't know if this is a factor but I thought I would include in this post. So my AVG rate for Dec 2008 is 1.3836 and my [END] rate for the same period 1.4244. I have accounts that I want to apply the difference on the rates to but when I run the fx restatement, instead of applying the difference (.0408) it is applying something like (-.0207). The account I am translating is [AVG] type. Has anybody any ideas why this might be happening ?