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!
2 of 2 people found this helpful
thank you. I've used MAX() as mentioned in the link and it worked for me:
str(round(MAX([Result])*100,1)) + "%"