5 Replies Latest reply on Sep 26, 2013 4:39 PM by Brandon Avants

    Simple Calculation.  ADR

    Brandon Avants

      Howdy Tableau Super User World,

       

      OK so I have a very simple average daily rate calc that has caused me to loose my sanity, what little I had anyway.

       

      So, here goes.

       

      I need to get total room nights so

      sum([No of nights]) * sum([No of Rooms])

       

      Then I need to get ADR

      sum([Net Transaction Spend]) / ([Total Room Nights])

       

      I've scrambled these eggs differently so many times I have no clue now.   This doesn't work and it's not even close.