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.