1 comment

  • Avatar
    Katie Garrison

    Hi Karen,

    If all of your data with leading zeros will always be some sort of numerical string (ie there will not be values like 000{character}) you could create a custom column using the following expression in the Elasticube:

    WHEN Left([Values],1) = '0' THEN ToString(ToInt([Values]))
    ELSE [Values]

    You might be able to do something similar with the IfInt function as well.

    Hope that helps,
    Katie Garrison | Technical Solutions Consultant


    Comment actions Permalink

Please sign in to leave a comment.