Hello,
Is it possible to extract a single column from refrows. I will perform calculations on the “extracted column” and display result in parent record.
Solved! Go to Solution.
You could even do:
SUM([Related somethings][Duration])
to sum the contents of the Duration column of the rows identified by the Related somethings column.
If by “refrows”, you mean a column with an App formula expression that uses REF_ROWS(), you’ll need to use SELECT() to get the specific row and column, then ANY() to convert the List result to a singular value:
ANY(SELECT([Related somethings][wanted-column], match-expr))
To clarify, the inline table has a duration column. My goal would be to access that column. Yes, I using Ref_Rows to display the inline table.
You could even do:
SUM([Related somethings][Duration])
to sum the contents of the Duration column of the rows identified by the Related somethings column.
Thank you! @Steve
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |