FM Pro Help

Thread View: comp.sys.mac.databases

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by John Ratcliff Thu, 21 Jan 1993 22:58

#643

Author: John Ratcliff
Date: Thu, 21 Jan 1993 22:58

33 lines
1802 bytes

I am trying to summarize info in an Invoice/Purchase order type
format. Repeating fields are nice but seem very limited.
Maybe I am asking too much of a non relational DB.

Does anybody have any recommendations for summarizing items
on an Invoice. That is , how do you find all items of a certain
type code in one repeating field and total the dollar amounts
from another repeating field.

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.
Sub Summaries only pick up the first occurence in repeating fields.
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

Thanks for any help.
John Ratcliffe  UCSD
ratcliff@ucsd.edu

Re: FM Pro Help

#657

Author: Brian Hughes
Date: Mon, 25 Jan 1993 17:27

37 lines
2116 bytes

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
--

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads