I Need Help Setting Up Variables to Perform Calculations Correctly
I need some help setting up variables to perform calculations correctly. This is what I want to achieve.
Learners are supposed to do certain actions like review certain slides, watch videos, and click certain tabs in a particular order.
Each module starts with a total risk number which I have named 'RiskStart', as learners do these activities, their 'Risk Score' reduces. The calculation for this is:
RiskScore = ((RiskStart-RiskCount)/RiskStart))X 100
RiskCount is the count of learner doing the number of actions available
Also, is there a way of adjusting the Results variables? What I want to do is that the learner's final score will be reduced by a certain number based on the range within which their ending RiskScore falls.
1. if the RiskScore is below 10%, the final ResultsScorePercent will not be affected.
2. If RiskScore is from 10% but less than 50%, the final ResultsScorePercent will be reduced by 5%
3. and If RiskScore is more than 50% at the end of the module, the final ResultsScorePercent will be reduced by 10%
Kindly find attached a sample of the file with what I tried doing. Any help in setting this up correctly is appreciated.
Thanks very much.