Rates to charge extra for 1 adult and 2 children

Q: We charge for more than 2 people, but the cost is different for extra children vs. extra adults so I can't use the normal method of just setting the reservation field to "# Children + # Adults".  I'm having trouble doing the rate if they have 1 adult and 2 or more children....if 2 or more adults, it's fine.  But for 1 adult and 2 children, how can I get it to only charge for the 1 extra child, not both?

A: You can do it by having 2 separate rates for extra children -- one that applies if there's 1 adult and another for 2 or more adults.  The trick to that is to use the Advanced Condition Expression.

In the extra child rate for 1-adult, set the Advanced Condition to:

 Resv:Resv_Adult = 1

and set the "Applies if Resv field" to:

 # Children >= 2 per each more than 1

In the extra child rate for 2 or more adults, set the Advanced Condition to:

 Resv:Resv_Adult > 1

and set the "Applies if Resv field" to:

 # Children >= 1 per each more than 0

The Extra Adults rate would be done the normal way (# Adults >= 3 per each more than 2), nothing special about it.

A similar method would be used if you allow 4 people, e.g. 2 adults + up to 2 children, or 1 adult + up to 3 children.  Again, this is only necessary if you charge different amounts for extra children than you do extra adults (if the price is the same for adults and children, you can just use one rate with "# Children + # Adults" >= 5).  

This first example assumes that you charge for more than 2 adults even if there are no children.  In other words, you include 1 adult plus 3 children at no cost, or 2 adults plus 2 children.  Any more than 2 adults (or more than 4 total people) gets added charges.

You'll need 5 separate rate definitions.  Two of them will need "Advanced conditions", as above.

1. Extra adults : just the standard Extra adults rate, # Adults >= 3 per each more than 2.

2. Extra children if 1 adult : Set it to # Children >= 4 per each more than 3.  In the Advanced condition, put:  Resv:Resv_Adult = 1

3. Extra children if 2 adults : Set it to # Children >= 3 per each more than 2.  In the Advanced condition, put:  Resv:Resv_Adult = 2

4. Extra children if 3 adults : Set it to # Children >= 2 per each more than 1.  In the Advanced condition, put:  Resv:Resv_Adult = 3

5. Extra children if 4+ adults : Set it to # Children >= 1 per each more than 0.  In the Advanced condition, put:  Resv:Resv_Adult > 3

Now if you allow 4 people whether Adults or Children, then the Extra Children rates are the same as #2 through #5 above, there's only one difference in the first rate (Extra adults:)

1. Extra adults : just the standard Extra adults rate, # Adults >= 5 per each more than 4.

(and rates 2 through 5 the same as above)