8 Replies Latest reply on Apr 15, 2016 5:50 AM by Lucy Jones

    I need some urgent help. I have a target number (numerical field), when the target is a zero I want to show TBD instead of the zero.

    Lucy Jones

      I have tried using this formula....

      if [Target] = "0" then "TBD"

      else [Target]

      end

      but it says that it cannot compare float and string values.

       

      I am using access as the source so I cannot change the source to show TBD instead of the zeros as it is a numerical field.

       

      I am using tableau v8.3.

       

      I would be so grateful if someone could help me get the right formula. I have a deadline of 11.30am today so would be extrememly grateful of a quick response.

       

      Thank you

      Lucy