Average calculation when divisor changes

303
1
05-04-2018 09:10 AM
RyanKnox
New Contributor II

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!!

0 Kudos
1 Reply
RyanKnox
New Contributor II

I was able to accomplish it using 'if-then' statements and relevant questions. Good for me!

0 Kudos