I have two models based on a customer billing object. They are both aggregate models. The first is designed to aggregate all open billings for each customer. The second is designed to aggregate all open billings so that we can view total open billings for our company. I would like to model lookup the value displayed in the second object into each line of the first aggregate model, but am having trouble doing so. Example:

Aggregate 1:

Open Billings (each line will possible contain multiple billing)

Customer 1 - $30

Customer 2 - $60

Customer 3 - $40

Aggregate 2 -

Total Open Billings: $130

I would like to get the $130 value place on each line of aggregate 1. Thanks for the help.

Aggregate 1:

Open Billings (each line will possible contain multiple billing)

Customer 1 - $30

Customer 2 - $60

Customer 3 - $40

Aggregate 2 -

Total Open Billings: $130

I would like to get the $130 value place on each line of aggregate 1. Thanks for the help.

Danny Hartley

Yes, the second aggregate model only has 1 row.

With your solution I am now pulling a number, but it is the incorrect number. The number is larger than the number shown on Aggregate 2. Any ideas? I checked the condition on both models to ensure they were the same, and they both feed from the same object.

Christine Jessen

Danny Hartley

Aggregate 1 UI field:

Model Lookup in Aggregate 1 UI field formula:

Aggregate 2:

Aggregate 2 Aggregation:

Christine Jessen