Inventory of animals - possible circular reference.

Hi Angus,

I believe you can reverse the logic by starting from your output, I’ve just answered a similar question here:

You can transpose these calculation steps:

1. Source input = the amount to start with
2. Closing balance (Sheep) = previous(Year) + Source input + previous(Year)*Lambing rate
3. Amortisation  = (Closing balance * Lambing rate) [select: Year-1]
4. Opening balance (Lamb) = Closing balance[select: Year-1]

Please let me know if that helps getting your Sheep on their feet. 🐑

Best,
Benoit