Hello, I have this Select function that works perfectly and returns the value “Week , Height growth - weekly (cm)”
SELECT(User[Fields], [User_Email] = Usersettings(username))
Yet when I wrap this same function in an IN statement to detect if it returns “Week”, it return False instead of the expected True.
IN(“Week”, SELECT(User[Fields], [User_Email] = Usersettings(username)))
Any help on what I am missing here would be much appreciated.
Solved! Go to Solution.
Hi Aleksi, thank you I wrapped my select statement in a SPLIT() statement to ensure it was a list and this worked.
If it will return only one value, you should use the whole string for the IN expression like…
IN(“Week , Height growth - weekly (cm)”, SELECT(User[Fields], [User_Email] = Usersettings(username))). Is that the case?
Hi Aleksi, thank you I wrapped my select statement in a SPLIT() statement to ensure it was a list and this worked.
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |