Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAResulting 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". 🤣🤣