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.
Hi in my Input the data contains the values
and I want ouput as
I have tried Round formula but it didnt showed up correctly.
You can do it with below config.
Roud() actually rounds to the nearest thousand.
Hope this helps : )
Use a formula tool and put: Round([YOURFIELDNAME]/1000,1)
(Heh, am i going crazy or where both posts above edited recently? And yes probably not even a round formula needed :))