Hello Skuid Community!

I am currently trying to build a table that will show a single row of six columns where 4 of the columns are calculated based on the first 2. One will be a drop down where a percentage is selected and then the values are calculated. Please see the image below for the mock-up.

Thus far I have the first two fields from the model and then I have built UI-Only fields to create the calculations but I have been unsuccessful in making the table generate the calculations in real time.

Any direction in accomplishing this would be very helpful!

Thanks all.

I am currently trying to build a table that will show a single row of six columns where 4 of the columns are calculated based on the first 2. One will be a drop down where a percentage is selected and then the values are calculated. Please see the image below for the mock-up.

Thus far I have the first two fields from the model and then I have built UI-Only fields to create the calculations but I have been unsuccessful in making the table generate the calculations in real time.

Any direction in accomplishing this would be very helpful!

Thanks all.

Michael Schniepp

Skuidward Tentacles (Raymond), Champion

So you need the first two fields from the agg model, but you need to be able to update fields on the object.

You could try making a regular model on the object in addition to the agg model. Then you could use the model lookup function of UI only formula fields to pull in the two agg model fields Into the regular model. You could have a UI only formula to display the original renewal book and the book won fields, then additional UI only formula fields to do the math based on those fields.

Michael Schniepp

Skuidward Tentacles (Raymond), Champion