Unit linking

[fibayne]

Running sum brougtht forward total

Hi...I am in the process of building a life assurance database that has unit linked products and am having trouble calculating the latest unit price for a transaction, i have attached a spreadsheet to show how it should work, if anyone has done this before and could give me some help it woulf be greatly appreciated.....thanks Fi

 

[fibayne]

Hi

I have tried to better explain what I am trying to do on the attached word doc as I keep getting error messages with the calculations I am trying and am going round in circles, there is a circular reference which I cant work out, I am sure there is a way to do this and if anyone can help me out would be great....thanks Fi