1 2 Previous Next 19 Replies Latest reply on May 30, 2016 3:51 PM by ucharles

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

    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.

        1 2 Previous Next