AnsweredAssumed Answered

Calculation involving a Case Function

Question asked by ucharles on Aug 25, 2016
Latest reply on Aug 28, 2016 by ucharles

Esteemed Filemaker gurus, I used the "Case function" to determine or categorize classes of livestock:

 

class =

Case (

age < 365 and sex = "Female" ; "Calf-Female" ;

age <  365 and sex = "Male" and Castration = "Yes" ; "Calf-Male" ;

age <  365 and sex = "Male" and Castration = "No" ; "Calf-Male" ;

 

 

age < 730 and sex = "Female" ; "Heifer" ;

age < 730 and sex = "Male" and Castration = "Yes"; "Steer/Tollie" ;

age < 730 and sex = "Male" and Castration = "No"; "Young Bull" ;

 

 

age ≥ 730 and sex = "Female" ; "Cow" ;

age ≥ 730 and sex = "Male" and Castration = "Yes" ; "Ox" ;

age ≥ 730 and sex = "Male" and Castration = "No"  ; "Bull" ;)

 

The formula worked fine, but now for testing of pregnancy I want to use a combination of  "Heifer" and "Cow" as a group, which would be : age > 365 and sex = "Female". I am currently able to filter LivestockID drop down using a global field that has "Cow", "Bull" and so on. What do I do if I want to limit the drop down to both "Cow" and "Heifer". I have attached the file for easy reference. Go layout LIVESTOCK_PregnancyDiagnosis.

Attachments

Outcomes