Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need help with Formula
- Thread starter granny1
- Start date
Try this...
IF {table.rating} < 1.5
THEN "dissatisfied"
ELSE IF {table.rating} > 1.5 and {table.rating} < 2.5
THEN "Not up to expectations"
ELSE IF {table.rating} > 2.5 and {table.rating} < 3.5
THEN "Fair"
You would then use a summary to average all the responses, and use the same formula to apply "dissatisfied", etc. to the summary (total average). Just replace "{table.rating}" with your summary field name.
IF {table.rating} < 1.5
THEN "dissatisfied"
ELSE IF {table.rating} > 1.5 and {table.rating} < 2.5
THEN "Not up to expectations"
ELSE IF {table.rating} > 2.5 and {table.rating} < 3.5
THEN "Fair"
You would then use a summary to average all the responses, and use the same formula to apply "dissatisfied", etc. to the summary (total average). Just replace "{table.rating}" with your summary field name.
One correct for theDeej's post. You need to add some "="s to the formula. Without them, results of 1.5, 2.5 and 3.5 will be an empty string.
IF {table.rating} < =1.5
THEN "dissatisfied"
ELSE IF {table.rating} > 1.5 and {table.rating} <=2.5
THEN "Not up to expectations"
ELSE IF {table.rating} > 2.5 and {table.rating} <= 3.5
THEN "Fair" Mike
IF {table.rating} < =1.5
THEN "dissatisfied"
ELSE IF {table.rating} > 1.5 and {table.rating} <=2.5
THEN "Not up to expectations"
ELSE IF {table.rating} > 2.5 and {table.rating} <= 3.5
THEN "Fair" Mike
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question