I'm trying to create a Measure that sums a field of datatype Char. Every time I process the cube with this new measure it errors out

The reason the Measure has a field of datatype char is that the field returns values that can be used for descriptions and calculations Eg., "Survey values like Yes, No, High, Low, Big, Small, 5000 feet, 8000 inches, etc.) If the field contains data need for calculations (eg., "5000 feet"), I want to convert that data to integer and use data for calculations

Thanks.