7 Replies Latest reply on Aug 13, 2019 4:41 PM by John Sarantos

    Split String Number Will Not Convert to Integer

    Richard Cheslo

      I thought this would be a simple exercise with game scores, but it is proving to be difficult. I am using an Excel sheet as an extract data source. The Score column is a String of two numbers separated by a colon such a 2:3 or 11:4. I split the field into two new fields and they display fine as long as they remain Strings, however when I try to convert them to an integer or a float as either a dimension or measure all I get are Null values. I have tried variations of the calculation below, multiplying by 1, LODs, anything I can think of to no avail. Anyone have a suggestion? Thanks!