🚀 go-pugleaf

ratcliff@ucsd.edu (John Ratcliff) writes:

>To try and make it clearer suppose each record looks like this:

>Item      Description                 Type Code     Amount
> 1        Acme Road Runner Trap       AB123         $55.00
> 2        10 D Nails                  AB121         $ 1.01
> 3        2 by 4 10 ft                AX432         $ 4.89
> 4        Chicken Wire                AB123         $ 2.05

>How do I get a dollar total across multiple records of this
>type with possibly Multiple Type Codes in one record.

    If Amount is a repeating field, then you can use the calculation
formula Sum() which takes a repeating field as input and gives you the
total of all the elements in the field. You would then be able to use
a Summary Total field to get the totals across multiple records.

>Unfortunately the number of possible type codes is large and it
>would be difficult to predict which ones will be entered.
>So some sort of dynamic Type Code summarizing is needed.

>ie:    Type Code     Grand Total 
>        AB121          $45.56
>        AB123          $34.45
>        AB234          $ 3.98
>        AX432          $ 5.50

    This kind of information would be extremely difficult to get using
FM Pro. You would need a separate record for every item and then you
would be able to distinguish which items used which codes. This will
give you a database with a ton of records that are all really small, as
opposed to a database with a smaller number of records that are fairly
large.

-Hades
--