1 2 3 Previous Next 31 Replies Latest reply on Apr 11, 2016 8:46 AM by Mike_Mitchell

    Summary Field in a Sub-Summary Part

    rtolliver

      I'm looking for suggestions for how to perform a logical function on a Summary Field in a Sub-Summary part.  In the attached layout the Summary field represents total BdFt."Total_BdFt", the Logical function is

           If[Total_BdFt<= Th_Low]

                Set Field[OrderSpecie: "Order"]

           End If

      --------------------------------------------------

      Total_BdFt is the Sum(BdFt.)        //Both of these field are in table1

      Th_Low is the Low threshold value used to reorder    // This field is in a related table2

       

       

      This script runs when the layout is opened but does not set the OrderSpecie field if the condition is met.

        1 2 3 Previous Next