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