Around the World and Adding Summaries

[mgxdigital]

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]

[mr_vodka]

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?

[mgxdigital]

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.

[mr_vodka]

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.

[mgxdigital]

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?

[mr_vodka]

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.