We have a UI only model lookup to an aggregate model of quote line items to return the value of a specific product to the Quote model. However when there’s no product in the quote line items the formula returns a -1 value. The model lookup formula we’re using is: MODEL_LOOKUP(QuoteLineSum, sumSubtotal, product2SubFamilyc, “Management Discount”) where subfamily is the specific product we need to pull the value for. We’ve also tried a JS snippet to reevaluate the formula and it still shows -1.
var params = arguments,
$ = skuid.$;
var model = skuid.model.getModel(“Quote”);
We’re completely stumped as in the console the QuoteLineSum object has no data rows with a value of -1 but in the Quote object where the UI formula lives, the data rows are showing the -1 value.
Anyone have any insight?