Hi,
We have a Quality Assurance form in Excel which we hope to transpose to PowerApps.
I think I can manage building the form (layout and data submission). I would need help in getting/computing the scores. I really can't get my head around creating number formulas in the app.
I have attached the form with formulas that you can play around with.
Here's how it works:
1. The form has 2 main sections. Each section makes 50% of the overall QA score.
2. Each question will be rated as Yes, No, or N/A.
3. Each question has a point value of 1.
4. If the parameter is tagged as N/A, the point value should be set to 0, and should not be computed as part of the total possible points. You can see the total possible points in rows 110 - 126 of the excel file attached.
I would really appreciate it if you can help me replicate this form in PowerApps.