5 Replies Latest reply on Sep 26, 2013 4:39 PM by 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.

• ###### 1. Re: Simple Calculation.  ADR

What's wrong about it - what should the value for Residence Inn be for example?

• ###### 2. Re: Re: Simple Calculation.  ADR

Now I believe I have some simple math mistake.  Attached is just RI rates, gross and nights.

If my ADR is never for any given row less than \$90.625 how can the total be less than the rows at \$20.93697?

Maybe it's way too early

• ###### 3. Re: Simple Calculation.  ADR

Your math is wrong. You need a per row calculation for nights *rooms, sum this and use it to divide out the cost. The ADR is 129.32

• ###### 4. Re: Simple Calculation.  ADR

Thanks buddy!!!

• ###### 5. Re: Simple Calculation.  ADR

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

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

It needs to be just

sum({net transaction sped})/([No of nights]).  No of nights in this case was all room nights so you would never double do and do no of nights times no of rooms.