Skip to main content

I am new to airtable and am having trouble.  I have a cattle ranch and am working on a database to manage their reproduction.  I would like to calculate each cows conception rate based on the number of times she has become pregnant vervus the total number of opportunities she has mated.  For example, if she has been with a bull 10 times and has become pregnant 7 times in her lifetime, then her conception rate is 70%.

I have each cows breeding records in the data.  I also have a field titled “pregnancy status.” If i use rollup for this field with:

Source= Cattle ID#

Cattle field to rollup= Pregnancy Status

Pregnancy status field is: pregnant or non-pregnant

How would I create a formula that would look up the pregnancy status for each mating and then calculate the percentage pregnant for the cow’s lifetime?

 

Thank you so much for any help you can give me!

 

 

Hey, this is quite an interesting project. 

I would advice having another table that tracks the attempts. 

 

Attempt 1 | Link to bull 1 | Link to Cow 1 | Result

 

Then on the Cow table you would have a linked property with all the attemps.

 

then you can create two count fields. 

One counts all the attempt lets call it “Attempts count”, the other would count only the ones in which the outcome was positive lets call it “Positives“. (you can set up in the filed itself)

 

The it is just a simple formula in which you have {Attempts count}/{Positives}. This will be a percentage

If you have any question I am happy to jump on a call

 

Wow, you are so helpful.  I know it seems like a basic question  but I’m just a rancher.  I will work on it right now.  

 

Hope you have a great day!

Hmm, could you provide a screenshot of your tables?  It kind of sounds like you already have one record per opportunity in your breeding data

​@Leftycasey happy to help 🙂.

 

Let me know if you managed to do it, otherwise I can give you some insight

Felipe you fixed my problem.  Thank you everyone for helping me.

Reply


Terms & Conditions