Average doesn't give me expected result
Hi there,
when i do a =ROUND(AVG formular as shown below i expect to get "2" for the average of 1 and 3.
But it shows 3. Any idea how to fix this?
Thank you,
Manuel
Best Answer
-
Because your formula that is outputting the numbers is outputting the 1 as a text value which is not recognized. The AVG function is picking up on only the 3 since it is the only numerical value. Try removing the quotes from around the "1" in the number output formula and see fi that fixes things for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
The input numbers comes from a another formular to convert the emojis into numbers first. It shows the correct numbers but average calculation doesn't work. When i do not use a formular as input for the average calculation (like 1 and 3 without emoji formular) it works as expected and shows "2"
-
Because your formula that is outputting the numbers is outputting the 1 as a text value which is not recognized. The AVG function is picking up on only the 3 since it is the only numerical value. Try removing the quotes from around the "1" in the number output formula and see fi that fixes things for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Ahh, thank you. That was an easy fix! :)
-
Sometimes we get lucky. Haha.
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!