How would I sum just the values that are related to the record im currently on, instead of the whole table?
Create a Formula field:
Yeh worked it out, by mistake one record was hiding due to the size of the sub table and I though the calculation was wrong but it wasn't.
What about summing specific record, say it one was a reversal sum((select Milestones where type = 1).amount)?
This does not seem t work.
Yes it works...
Ok that works on the parent, but what about child, if I use that code, it does it for all records in the child and forgets the relationship.
let t := this;
sum((select Milestones where Milestones = t and Type = 1).Amount)