1 Reply Latest reply on Jul 22, 2014 12:10 PM by philmodjunk

    Field that counts.. based on data being present in other fields

    MattW_1

      Title

      Field that counts.. based on data being present in other fields

      Post

           I have 5 rows of data each with (weight, length, width, height). I’m trying to create a field called “pallet total” So if Row1 has data in (weight, length, width, height) I want that to count as “1”. If “row 2” has it fields not entered or only some of the fields entered I don’t want it counted. 

           The goal is to have Pallet total showing the grand total of pallets for shipment based on the rows with complete data. Any ideas? Thanks..

        • 1. Re: Field that counts.. based on data being present in other fields
          philmodjunk

               Selective sums of related data can be computed in a number of different ways.

               One way is to use ExecuteSQL with a WHERE clause that excludes the records you don't want part of your total.

               Another is to add calculation fields that use IF or Case Functions to make them empty if the data from that records is not to be included. Then your summary fields or calculation fields in the parent record with sum functions sum these calculation fields instead of the original fields.

               Or a new occurrence of the related table can be used in a relationship that automatically omits the related records you don't want to be part of this total.

               And a summary report based on the related table instead of the parent table can compute the needed totals simply by using  a find that omits the incomplete records.