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.