Help need to subtotal a field using UI

edited December 2019 in Problems
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
image

Model 2
image

Comments

  • Josh LewisJosh Lewis Member
    edited January 2019
    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
  • edited June 2018
    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%)


  • GregGreg Member
    edited December 2019
    Any solution to this? I have a similar need and have reviewed the UI-Only documentation but haven't been able to work out a solution.
Sign In or Register to comment.