Forum Discussion

MICHAELSARGENT's avatar
MICHAELSARGENT
Qrew Cadet
3 years ago

Summarize value from List-User Field

I have a child table that contains a user-list field.  I want to summarize the user selected from the user-list field in the parent table.  I tried things that normally worked with standard user field...
Formulas and functions
Relationships
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
3 years ago
Create a field on the child called [UserList (text format)] with a formula of 

ToText([My User List Field])
Roll that up to the Parent using a Combined Text summary field.

Then on the parent make a formula List User field.

var text AllUsers = ToText([UserList (text format)]);

var user UserOne= ToUser(Trim(Part($AllUsers,1,";")));
var user UserTwo = ToUser(Trim(Part($AllUsers,2,";")));
var user UserThree= ToUser(Trim(Part($AllUsers,3,";")));


ToUserList($UserOne, $UserTwo, $UserThree) 

Extend this up to 20 following the pattern.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------