Using the simple steps below, we can demonstrate how the error happens to better understand this unique scenario:
1. Go to Lists > Search > Saved Searches > New > Transaction.
2. Under the Results tab > Columns sub tab, add:
• Formula (Text)
- Type this value in the Formula field: 'user'
4. Preview. "ERROR: Invalid Expression" appears in the Search Results.
This errors because the word "User" is a reserved word and is not recognized as a string in the system.
To avoid this error concatenate the characters to form the word "User". Like:
• CONCAT('Use', 'r')
• 'Use' || 'r'
Post a Comment