0
Sum sub table
How would I sum just the values that are related to the record im currently on, instead of the whole table?
8 replies
-
Create a Formula field:
sum(Milestones.Amount)
-
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.
-
Try this:
let t := this;
sum((select Milestones where Milestones = t and Type = 1).Amount) -
-
Content aside
- 4 yrs agoLast active
- 8Replies
- 1589Views