This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!
Submit FeedbackResulting percentages based on 1839 rows - I don't think dividing by 1850 is the right approach here.
Hi All, here is my solution
Voila
For the life of me I can't get the same percentages but I can't see where I've gone wrong! 😬
I had the same issue. The solution in the output uses the SmartRound formula (exactly what you have, except the [Count by Size]/[Total Entries] part of the equation is enclosed by the SmartRound function). if you do that, your percentages will match the solution.
I was never able to fully determine what the SmartRound function does, but it's the only way that the results match the output set.
Thanks, @tammybrown_tds - I'll take a look at that. My solution was never going to be "SMART". 🤣🤣