I'd like to give a discount based on number of camp sessions signed up for: 2-3 sessions get a 5% discount; 3 or more sessions get a 10% discount. I tried the following formula:
=(if TotalNumberOfSessions > 3 then -0.1 else if TotalNumberOfSessions > 1 then -0.05 else 0) *TotalNumberofSessions
but I get this error message:
Operator '>' incompatible with operand types 'String' and 'Int32' at character 26
and can't figure out what the message means.
Can you tell me the formula I need to use to calculate that?