AnsweredAssumed Answered

Portal that list records based on filtered calculation field from a Self-Joint TO

Question asked by ucharles on May 30, 2016
Latest reply on May 30, 2016 by ucharles

I have a calculation field in a self-joint table called LIVESTOCK, the TO of  LIVESTOCK   is called CLASS.

 

 

Calculation =

Case (

age ≤ 345 and sex = "Female" ; "Calf-Female" ;

age ≤ 345 and sex = "Male" and Castration = "Yes" ; "Calf-Male" ;

age ≤ 345 and sex = "Male" and Castration = "No" ; "Calf-Male" ;

 

age ≤ 720 and sex = "Female" ; "Heifer" ;

age ≤ 720 and sex = "Male" and Castration = "Yes"; "Steer/Tollie" ;

age ≤ 720 and sex = "Male" and Castration = "No"; "Steer/Tollie" ;

 

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

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

age ≥ 720 and sex = "Male" and Castration = "No"  ; "Bull" ;

)

 

 

Now I want list how many "Cow", "Heifer" or "Bull" etc in a portal IN CLASS_List layout based on the CLASS  table. Preferably one where I can use a pull down menu to select the class I want to list.

 

 

I have a feeling easy but yet it beats me. Could you please help.

Outcomes