Sum sub table
S

How would I sum just the values that are related to the record im currently on, instead of the whole table?

table

Ninox Profile

Create a Formula field:

sum(Milestones.Amount)

S

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.

S

What about summing specific record, say it one was a reversal sum((select Milestones where type = 1).amount)?
This does not seem t work.

Ninox Profile

Yes it works...

Clipboard01

S

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.

Ninox Profile

Try this:

let t := this;
sum((select Milestones where Milestones = t and Type = 1).Amount)

S

Annotation 2020-01-15 152826

Ninox Profile

Clipboard06

 

Clipboard07

Reply