Help need to subtotal a field using UI

  • 1
  • Problem
  • Updated 5 months ago
  • In Progress
  • (Edited)
I'm new to Skuid.

I'm trying to get the sum of the project from the field Testqtrf (Testqtrf is a UI field which is %complete * Amount -incl. deliverables) of the same project and populate it into the field Current Quarter Amount in Model 2. 

You will notice Tullow WR 25 has two project. So the Sum of Testqtrf needs to be populated into Current Quarter Amount field. 

Suggestions are welcome. 

Model 1


Model 2
Photo of Toms Vineeth John

Toms Vineeth John

  • 428 Points 250 badge 2x thumb

Posted 6 months ago

  • 1
Photo of Josh Lewis

Josh Lewis

  • 1,218 Points 1k badge 2x thumb
Hello Toms,

Have you had a chance to check out our documentation around UI-Only Models and Fields? This page: https://docs.skuid.com/v11.1.13/en/skuid/models/ui-only-models-fields.html has a handful of documentation and examples for using UI-Only features that might prove handy for you to reference.

Thanks,

Josh
Photo of Toms Vineeth John

Toms Vineeth John

  • 428 Points 250 badge 2x thumb
Hi Josh,

I went through the material. What i'm trying to do is the following:

POC*Amount (including Deliverable)
So from the above example the result to populate under the column Current Quarter Amount is the following: 709,7744 = (584401*100%) + (125373*100%)