I want to sum the points of a particular category. I've gone through all the questions and added it to a category (Comp, Goal, or Win), but I don't see how to do that calculation. I've tried CATEGORIES(Comp). I've tried CATEGORIES("Comp"). I've tried POINTS(CATEGORIES("Comp") ).... Is there a way to use the category feature without individually tagging every question (POINTS(@Q1 @Q5, etc...)?
Hi Brenda, If you have already assigned a category to questions in the form, then you can easily calculate the category using the POINTS(CATEGORY, ... ) formula.
For example, if you have assigned "Comp" as the category name, you can use POINTS(CATEGORY, "Comp") formula to add all the points for questions marked as Comp. Similarly, you can calculate the other category scores. Please note that the category name is case sensitive.
Wed Jan 24 2024
| 2 Replies
