Problem with discount

I set 5% discount for 4 nights, 10% discount for 5 nights, 15% discount for 7 nights. I have a Vrbo guest booked for 7 nights and all 3 discounts were applied and she ended up receiving 30% discount. How do I fix this???

On the lower two % discounts, you just need to apply multiple criteria to them. For example:

10% Discount for 5 nights:

• Where Number of Nights is Greater Than or Equal to 5 nights
• Where Number of Nights is Less Than 7 nights

5% Discount for 4 nights:

• Where Number of Nights is Equal to 4 nights

Or

• Where Number of Nights is Greater Than or Equal to 4 nights
• Where Number of Nights is Less Than 5 nights