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!