Jump to content

Passing Summary Values


This topic is 6975 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6975 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.