Hi Having issues building a Formula with model lookup from another Agg Model

Here's my scenario:

I have 2 Aggregate Models: 1 Named 'TimesheetentryAgg' the other named: 'FundingAgg'

I want to use the result UI Field from 'TimesheetentryAgg' named 'TotalPaid' (this ui field is a formula field adding 2 Sum aggregations) for a calculation on model: 'FundingAgg'

So on 'FundingAgg' i created a UI Only field with this formula , just to see if value would show:

MODEL_LOOKUP("timesheetEntryAgg","TotalPaid")

And field return empty.

Note that the order of model load is correct, Timesheet is loaded before Funding

As well did not add 3rd and 4th optional parameter to model lookup formula , as from what i read on training guide, not always necessary and if i understood correctly an Agg model only has 1 row? and needed to use not sure what i can use as these 2 models have not much in common...

I would appreciate any help

Thx

Here's my scenario:

I have 2 Aggregate Models: 1 Named 'TimesheetentryAgg' the other named: 'FundingAgg'

I want to use the result UI Field from 'TimesheetentryAgg' named 'TotalPaid' (this ui field is a formula field adding 2 Sum aggregations) for a calculation on model: 'FundingAgg'

So on 'FundingAgg' i created a UI Only field with this formula , just to see if value would show:

MODEL_LOOKUP("timesheetEntryAgg","TotalPaid")

And field return empty.

Note that the order of model load is correct, Timesheet is loaded before Funding

As well did not add 3rd and 4th optional parameter to model lookup formula , as from what i read on training guide, not always necessary and if i understood correctly an Agg model only has 1 row? and needed to use not sure what i can use as these 2 models have not much in common...

I would appreciate any help

Thx