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, since you can just use one rate with "# Children + # Adults" >= 5 otherwise.  Note: To keep it simpler, we're assuming that you charge for more than 2 adults even if there are no children.

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

1. Extra adults : just 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 > 1