We’re currently using a bunch of javascript to make percentage calculations on an aggregate model.

I’d love to replace that with a ui-only formula field.

Here’s my attempt at a formula:

{{TotalRecords}} / MODEL_LOOKUP(‘numberOfSchedulingLeads’, ‘TotalRecords’, ‘Id’, ‘4’)

The formula isn’t returning anything. Is my syntax ok?

The fourth row of my model (Id=4) is the roll-up summary row. TotalRecords and Percentage are both COUNT(Id), and we’re using javascript to change the values of Percentage to a percent of the column sum.

The ui-only field is called PercentUI, but isn’t showing up in the model at all.