Age discount based upon age entered

I'm posting this here to help anyone else who has the same requirement.

I wanted to have a Discount calculated based upon the age entered during registration. I'm using this for a youth/student discount. If the participant is 18 or younger, I take $15 off the registration.

So if the age entered is 1-18, the formula field needs to return -15. If the age entered is 19 or older, the formula should return 0.

Using a custom field with a Text Field, the fee formula you would enter is:

Obviously, change the 18 to whatever age you want, and the 15 to the discount amount.

The only caveat is that unless you put a Default age value, the discount will be applied when first opening the Registration form because there is no value for age. One you enter in an age, then it will update correctly.

Interesting thing I learned, is that you can use PHP math functions in that formula field, you just can't use any conditionals.

Usual disclaimer: use at your own risk, not responsible for any issues or problems or loss of revenue.

Thanks Cory for sharing your solution with the community

Tuan