Formula Expression values are processed differently when selecting different system language NL-ENG

Sant

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*