Passing Summary Values

[naguszed]

I could use a hand with this...I'm kinda new...

I'm trying to pass a GetSummary result from one table to another. Is this possible?

I thought i could set-up a GLOBAL field in the same table, then look it up from a field in the other table. I the look-up field is always blank, even though the GLOBAL has a value.

Any help would be appreciated.

[transpower]

Assuming this involves a portal, from the Help file:

To summarize data in portals:

1. Create a calculation field in the table in which you want the summary to be displayed.

See Defining calculation fields for more information.

2. For the calculation field, define a formula that includes an aggregate function for the type of summary calculation you want to perform.

For example, if you are in the Invoices table and want to define a calculation to total the related values in the Price field of the LineItems table, use the formula Sum(LineItems::Price)

3. Place the calculation field on a layout of the table in which it is defined.

Does that help you? Note that GetSummary requires that the records be sorted by the break field.

[naguszed]

transpower-

I wasnt using a portal, but now i'm wondering if i should be.

I am trying to "closeout a cashddrawer", by summarizing the "invoices" since the last closeout. I have a daily closeout table set-up, to which I'm trying to pass the invoice summary.

[transpower]

I think a portal is perfect for your situation, and the method described in the FM Help file is precisely what you need to do.

[naguszed]

i got the portal going......thanks!