Select to view content in your preferred language

Average calculation when divisor changes

423
1
05-04-2018 09:10 AM
RyanKnox
Emerging Contributor

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
Emerging Contributor

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

0 Kudos