I'm building a Calculation View based on SQL Scripting. Within this Calculation View I try to use the CE-functions as much as possble.
One of the challenges is the conversion of a character field (containing numbers) to something like an integer.
So, is there a way of doing that within a Calculation View?
Using conversion functions the validation is always okay, but running the view always leads to errors (mentioning that the data type for a specific function is wrong).