Scorpion167

Summary Field in a Sub-Summary Part

Discussion created by Scorpion167 on Mar 29, 2016
Latest reply on Apr 11, 2016 by Mike_Mitchell

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.

Outcomes