Currently, our report transforms column A to Column B by using a Case - when - then setup.
For example,
- Case when column A = 'Value_1' then 'Value X'
- when Column A = 'Value_2' then 'Value Y'
Interestingly, when we change the system (user) language from NL to ENG there is a different behaviour by the system. Namely, the English settings does not properly read the underscore 'Value_1', while the dutch language setting does. Meaning, the value in Column B is still showing the same value as Column B even though we would expect 'Value X' and not 'Value_1'
I assume this is not designed behaviour but I might be wrong. As such my question is, can system/user language settings have an impact on how to system behaves regarding SQL queries / Formula Expressions?
P.S:
- Value_1's api-name includes the Underscore*
