Expression Assistant Test & AppSheet Output are not the same

I have a virtual column with values computed through the following formula. Using the TEST feature, I was able to confirm that the expression result is what I need.

db-side.png

However, when I save this and load the table in the app, the values are DIFFERENT. Not only are the values not what I expect, every row has the same value.

appsheet-side.png

I've tried this alternative formula: SELECT(Skill Details[Skill],IN([Row ID],[_THISROW].[Skills][Skill])), but the expression assistant threw an error at me: Error in expression '[_THISROW].[Skills][Skill]' : Unable to find column 'Skills][Skill'


Any idea how I can fix this?

Solved Solved
0 6 436
1 ACCEPTED SOLUTION

You will need an extra column for that

View solution in original post

6 REPLIES 6
Top Labels in this Space