Discussions
Casting values in expression builder
over 3 years ago by Des
Hello
We are currently using some of the MUF_* tables from Meet_master in some Business object expressions, however all of these are defined as Varchar(100), and we would like to be able to cast these to int so we can preform some arithmetic on the values.
Is there a way to cast these columns? We have tried creating a new BO and setting the column the type as integer, and a few different methods in the expression builder but when we go to apply that the column type is always varchar, and we are unable to use them in our equations. I know we can do this with IQA, however it would be easier to do complete this task in the BO as a source table.
Thanks,
Des