Hello,
I'm trying to determine the best way to set up a running calculation that uses previous records as the base.
Imagine, for example, 4 players play a game for the first time. The base score all players start with is 5000.
During that game, Player 1 gains 100, Player 2 gains 50, Player 3 loses 50 and Player 4 loses 100.
The NEXT time they play the game, I would like their base scores to reflect the changes from the last game (so, new scores would be 5100, 5050, 4950, 4900), and so on.
I've been able to set up relationships within the file to allow the 5000 to be placed, and for all the computations. The problem is, I'm unable to set up a calculation for the second playing, without creating a circular reference.
I do have a sample file, if anyone wishes to leave me a PM, with an email addy.
I'm using FM 5.5
Thanks for any help or ideas you can provide!
Chris
I'm trying to determine the best way to set up a running calculation that uses previous records as the base.
Imagine, for example, 4 players play a game for the first time. The base score all players start with is 5000.
During that game, Player 1 gains 100, Player 2 gains 50, Player 3 loses 50 and Player 4 loses 100.
The NEXT time they play the game, I would like their base scores to reflect the changes from the last game (so, new scores would be 5100, 5050, 4950, 4900), and so on.
I've been able to set up relationships within the file to allow the 5000 to be placed, and for all the computations. The problem is, I'm unable to set up a calculation for the second playing, without creating a circular reference.
I do have a sample file, if anyone wishes to leave me a PM, with an email addy.
I'm using FM 5.5
Thanks for any help or ideas you can provide!
Chris