Show sub table formula result in main form

I have a sub table that shows appointments, a marked delivered checkbox and invoice value. Within the sub table I have a formula that will add up the invoice values of all delivered appointment. So, I may have 5 appointments, each with a invoice value of £10 each. The total value of appointments would be £50. If I check the box that says appointment deliver on just 2 of them, my formula result shows £20 in a sum value at the bottom of the sub table. All good so far.

Now, I want to take that formula and put it on the main form, so I see a "Value of Delivered Appointments" box.

I cannot copy the same formula from the sub table as it cannot find the data.

Any ideas?

1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 3 yrs ago
    • Reported - view

    Try something like this:

    let t := this

    sum((select YouSubTable)[TableReference = t and Checkbox = true].Amount)

Like Follow
  • 3 yrs agoLast active
  • 1Replies
  • 894Views