Strangeness when Using UI-Only Field on Aggregate Model to Sum From Another Aggregate Model I have two aggregate models in one page to count the Ids and group by a 5-option picklist from Leads and Contacts.The leads do not have any of one option from the picklist, where contacts have several thousand of that option selected.The two models look alike, however, I created a UI-only aggregation on the contacts model that looks at the leads model to add the Id count on the leads model to the Id count on the contacts model to give a sum.This works well when both models have a non-zero number in the same grouping, ex: if both models have a count in the grouping for “Marketing” status, then I get the sum.The problem is when one model has an Id count for another status such as “Unqualified,” let’s say 23 for contacts - and the other model leads does not have any rows that would aggregate to “Unqualified,” instead of the contacts model UI-only field stating 23 for “Unqualified,” the number the UI-only field reports is 0.
| Contact | Leads | Combo (UI-only on Contact Model) Unqualified
