# Around the World and Adding Summaries

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

## Recommended Posts

Hello.

[color:blue]My business works in rolls of paper. So [color:blue]everything we do is in lineal feet. We are trying to figure out a way to add up all of the footage we've sent out and show how far around the world we've went.

For rolls....I have a summary field of all of the final footage we've sent out for each customer.

For sheets...I have a calculation field that brings the total sheets sent out into total lineal feet sent out. And a summary field to add all of them together.

My problem is adding up all of the total roll feet and sheet feet for all customers.

I have 2 summary fields and I'm not sure there is a way to add those together.

Any suggestions on what to do??

Thanks! [color:blue]

##### Share on other sites

This should be doable. Can you shed some light on your structure? Are rools and sheets in two different tables or are they in the same table?

##### Share on other sites

They are in the same table.

I have the two summary fields adding up correctly, but I can't figure out how to add those 2 together and get a final number. If we search through different customers I want that final footage number to stay constant and up to date, but I just can't figure out how.

##### Share on other sites

Well you can use a selfjoin relationship perhaps using the cartestian join 'X' operator.

Then you can use the Sum () function on the related records.

##### Share on other sites

I can not do a self join relationship because they are both summary fields. The field is lightened out so that I can not click on it. Any other suggestions?

##### Share on other sites

Huh? You do a self join keyed on your primary key. Then you create a new calc that adds the Sum() of your child self join table occurence.

##### Share on other sites

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

## Create an account

Register a new account