I have an issue where I have a calculation that needs to use a variable that has a previous function in the definition.
This is what it looks like:
Month 01 | 02 | 03
Variable A 5000 | 2336 | 1434
Variable B 500 | 500 | 500
Variable C #ERR | #ERR | #ERR
Variable D 2336 | 1434 | 2770
Variable A is a previous function of Variable D.
Variable C needs to be calculated as Variable A + Variable B.
Variable B is an object.
When I try to set this calculation up I get a looping error.
If anybody can help me get this to work. It would be really appreciated.
thanks
This is what it looks like:
Month 01 | 02 | 03
Variable A 5000 | 2336 | 1434
Variable B 500 | 500 | 500
Variable C #ERR | #ERR | #ERR
Variable D 2336 | 1434 | 2770
Variable A is a previous function of Variable D.
Variable C needs to be calculated as Variable A + Variable B.
Variable B is an object.
When I try to set this calculation up I get a looping error.
If anybody can help me get this to work. It would be really appreciated.
thanks