4 Replies Latest reply on Jul 21, 2016 4:26 AM by Ashish Chaudhari

    if calculations

    Mark McClure

      Hi - I'm new to the calculations side of Tableau so forgive me if this is something simple.

       

      I want to be able to create a calculated field that is similiar to an excel sumif statement.

       

      I have data showing the number of searches and the number of hotel results that we returned for each.

      e.g. 6 searches returned 150 hotel results

       

      How do I create a calculation that shows the number of searches that had zero hotel results ?

       

      Any advice would be appreciated.

       

      Many thanks

       

      Mark