I have an inspection survey where the customer wants an average score for a series of questions. Trouble is the number of questions changes with the asset type being inspected. Can someone give me some help dynamically changing the divisor based on the previous type selected. Form is attached and Type column is highlighted. Thank you!!
I was able to accomplish it using 'if-then' statements and relevant questions. Good for me!