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?
Please use something like SUM(SELECT([Related actions][Column],TRUE)) with your own column names.
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?
SELECT(..., TRUE)
? TRUE? With SUM()?
The reason is simpleโฆ better to read it from the smaller virtual list than reading the whole child table again.
TRUE belongs to SELECT()
Whoops! I misread! My bad!
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |