1 Reply Latest reply on Jan 21, 2013 5:15 AM by Alex Kerin

    Only read up to "-" mark in a measure field (and any info on using fields with numerical ranges)

    Brad Mills

      I have some fields that contain ranges, like 14555.00-17356.00 or 685.00-1234.00. There are also many single values, like 876.00 or 32359.00.

       

      To top it off, they're in a varchar field..

       

      I'm getting an oracle error, I think on the - marks.

       

      How can I create a calculated field that will only read up to the - mark, or ignore everything afterwards?

       

      Further, are these types of range fields of any particular use in Tableau?

       

      Thanks so much!