Get Nth Record Calculation

[Steve T Cunliffes]

Hi,

 

I have a portal with various fields, the two in question however to explain my problem and without listing them all are called: - 

• Previous Years Remaining
• Remaining

When I go to a new record on the portal I want to get the value from the field 'Remaining' (from the previous record) and put it into the field 'Previous Years Remaining' in my new record. 

This I have managed to achieve by setting the 'Previous Years Remaining' field type to calculation and using the following function. 

 

GetNthRecord (Beneficiary Allocations For Accounts::Remaining_c ; Get(RecordNumber)-1 )

 

Why when the value or data in the 'Remaining' field is updated or changes however, the value in the 'Previous Years Remaining' field doesn't change or update with it.

 

I'm guessing that the GetNthRecord function does not perform like a calculation that say for e.g. adds two number fields together and keeps updating itself as and when data changes. 

I have tried hard to try and resolve this before asking for help but now out of ideas.

 

Any help would greatly be appreciated.

 

Cheers

Steve

[doughemi]

Is the Do Not Store checkbox checked in the 'Previous Years Remaining'  calculation options?  It should be

[Steve T Cunliffes]

I can't thank you enough, it works brilliant.

 

Thank you again.

 

Steve