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]


      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