Related Lists expression

[Luke_Vancleave]

Hi, I have a list of related actions that were done at a client’s worksite. How do I write an expression that SUMs a column from that list of related actions?

[Aleksi]

Please use something like SUM(SELECT([Related actions][Column],TRUE)) with your own column names.

[Luke_Vancleave]

Here’s what I just came up with in the mean time.
SUM(Select(Action Record[Cost of Action],[Client ID]=[_Thisrow].[Client ID]))
Any suggestions? I think you’ve mentioned to me before about having it look through the related actions instead of the whole Action Record table?

[Steve]

SELECT(..., TRUE)? TRUE? With SUM()?

[Aleksi]

The reason is simple… better to read it from the smaller virtual list than reading the whole child table again.

[Aleksi]

TRUE belongs to SELECT()

[Steve]

Whoops! I misread! My bad!