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
Question
Issue with Model Lookup

Translate
This topic has been closed for comments
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.