
1. Re: String of rounded figure showing more decimal places than formula
Steve Martin Sep 4, 2015 4:37 AM (in response to Ey Tan)1 of 1 people found this helpfulHi Ey,
This question was answered by both me and Simon about a month ago, it does need a new calc specifically to correctly handle the rounding:
Steve

2. Re: String of rounded figure showing more decimal places than formula
Ey Tan Sep 6, 2015 9:11 PM (in response to Steve Martin)I've included AVG to the number before I round it off and it's still not showing as intended.
the column 'Result' shows the data per the input file. (multiplying that by 100 gives the percentage it is supposed to show)
I've got no idea where those series of 9s and 0s in the 2nd to 4th columns came from .....
I got error msgs saying "content of this type is not allowed" when uploading my dummy excel file and TWBX.
The formulas I used for the above are:
 str(round(([Result]),3)*100) + "%"
 str(round(AVG([Result]),3)*100) + "%"
 str(round(([Result])*100,3)) + "%"
Any ideas to possibilities I could explore are much appreciated!

3. Re: String of rounded figure showing more decimal places than formula
Ey Tan Sep 7, 2015 2:14 AM (in response to Ey Tan)2 of 2 people found this helpfulthank you. I've used MAX() as mentioned in the link and it worked for me:
str(round(MAX([Result])*100,1)) + "%"