Solved

Inventory of animals - possible circular reference.

I am modelling the flock of sheep over a period of time.

The logic: 2023 sheep * lambing percentage = 2023 Lambs born

After one year the lambs born are added to flock of sheep. 2023 sheep + 2023 lambs

This is then multiplied by you lambing percentage to get you current year lambs births.

(2023 sheep + 2023 lambs)*lambing percentage = 2024 Lambs

And this repeats for the following years.

Best answer by Benoit

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:

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

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

Best,
Benoit

+15

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:

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

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

Best,
Benoit

Benoit - Pigment wizard

Sign up