Forum Discussion
A Solution to rounding in Storyline – without using Javascript
Normal
0
false
false
false
oNotPromoteQF />
EN-US
X-NONE
X-NONE
I found a way to round numbers in Storyline without using Javascript. The challenge was to show whole percentage numbers from calculated decimal numbers (i.e. 33% for 1/3 and 67% for 2/3). Searching through the forums, all I could find was Javascript solutions and suggestions to submit a feature request. Not happy with either of these answers, I continued to play around.
I found that Storyline only holds 7 digits past the decimal place, and the 7th digit is rounded. So to get a rounded decimal (percentage) as a whole number, divide by 100,000, and then multiply by 10,000,000.
For example:
2 / 3 = 0.6666667 (rounded at the 7th position by Storyline)
0.6666667 / 100,000 = .000006666667 (which is rounded to 0.0000067)
0.0000067 * 10,000,000 = 67
Now we have our rounded 67% from 2/3
You should be able to apply this to any number you want to round. Divide and then multiply by a multiple of 10 that is large enough to push the number you want to round to the 7th position past the decimal (i.e. 13,567 / 10,000,000,000 * 10,000,000,000 = 14,000)
Hello everyone,
I have some great news to share! We just released another update for Storyline 360. In Update 112, we’ve included essential fixes and new features. One of the new features we’ve included is:
- Simplify reporting with a built-in option that rounds quiz scores to whole numbers.
Launch the Articulate 360 desktop app on your computer to take advantage of this update, and click the Update button next to Storyline 360. You’ll find our step-by-step instructions here.
Please let me know if you need additional help.
100 Replies
- TomLunzerCommunity Member
Thanks for the tip. I needed to have rounded off percentages for my project.
This really should be an option that can be set in the quiz options.
I posted a feature request.
I am including a zipped up sample of the Articulate Storyline file here for others to see how this was set up. There is also a "Instructions" PDF file included with some screenshots of variables setup. My quiz here uses a number of question banks so the questions are randomized.
To sum up what happens is per previous instructions by Terri and others I have created a few triggers that divide and then multiply the quiz results Percentage score by 10000000. It does this to push the score percentage past the Seven digits limit decimal place.
- GarryGentCommunity Member
Thanks for the file Tom. Great way of solving the problem
- AntonioCommunity Member
Hi Tom,
Thanks a lot for sharing in the community how to do the rounding in such a didactic way. You saved my live when i was asked to do that just last day before turning in a project.
I will place a feature request, as you i think this need to be in quiz options.
- NavinLodhiCommunity Member
Thanks everyone! this is really cool and nice work around.
- PhilMayorSuper Hero
Jennifer Barnett said:
I ran into a similar issue and I didn't want to spend the time to make this edit since I only had a 3 question quiz so I found a really good alternative!
All I did was change the question scores from the defaulted 10pts (2 to 33pts and 1 to 34pts) and then changed the results display from %Results.ScorePercent% to %Results.ScorePoints%. That resulted in making the results rounded in less than a minute!
this will only work if your points add up yo 100, because you are no longer showing a percentage, points have to be integers - JenniferBarn063Community Member
I ran into a similar issue and I didn't want to spend the time to make this edit since I only had a 3 question quiz so I found a really good alternative!
All I did was change the question scores from the defaulted 10pts (2 to 33pts and 1 to 34pts) and then changed the results display from %Results.ScorePercent% to %Results.ScorePoints%. That resulted in making the results rounded in less than a minute!
- ShayRiggsCommunity Member
Just a quick note to say thank and report success using this technique!! I wanted a rounded percentage, so divided by 10000000 then multiplied by the same number did the job.
Craig Bellingham said:
I'm pretty new to Storyline - only one course produced so far but loving it - and I have been asked by my client if I can get the final score to always be a whole number. I used the trick above to create the variable 'RoundedScore' and it works great, but I don't know how I then get that variable to be the score passed back to the LMS when my 'submit score' button is clicked.
Is this possible?
Not sure of how to go about this, but I would suggest storing the actual score, and then customising the score display web page to do the number rounding job – doing this means you are not storing bogus data in your LMS database. - BrettRockwoodCommunity Member
Owen, thanks very much. I was just playing around with this and literally stumbled upon the 10,000,000 number making it work. It really is quite a clever workaround and works beautifully. Thanks again to everyone.
- OwenHoltSuper Hero
Divide by 10.000,000 and then multiply by the same.
For those who want the math logic behind this answer,
42.85 / 10,000,000 = 0.0000043 in articulate (dividing by 10,000,000 moves the decimal place 7 places to the left and the 7th decimal position gets rounded)
0.0000043 * 10,000,000 = 43.0 (multiplying by 10,000,000 moves the decimal 7 places to the right resulting in a whole number)
- GauravMittalCommunity Member
Thanks Owen......
- BrettRockwoodCommunity Member
Let me start by saying math isn't my strong suit but I can't seem to get this to work properly with the standard variable Results.ScorePercent. For example my score is 42.85% as reported by the Results.ScorePercent variable. I created a new variable called NonRoundScore as S. Yu suggested and set it to equal Results.ScorePercent. I then set triggers to divide it by 100,000 and then multiply it by 10,000,000. But the result of my NonRoundScore variable = 4285%. What I want it to show is 43%. I'm guessing that it is the numbers that I'm multiplying and dividing by but I can't seem to discover what the right combination is to get me to my magic 43%.
Anyone out there who can lend a hand...?
- TerryMcDonaldCommunity Member
Craig,
I haven't done much with the LMS side of Storyline, so I am not sure about passing the rounded score back to the LMS. Hopefully someone can shed some light on this for you.
- CraigBellinghamCommunity Member
I'm pretty new to Storyline - only one course produced so far but loving it - and I have been asked by my client if I can get the final score to always be a whole number. I used the trick above to create the variable 'RoundedScore' and it works great, but I don't know how I then get that variable to be the score passed back to the LMS when my 'submit score' button is clicked.
Is this possible?