How To Convert Text Numbers To Normal Numbers
Do you have a number that's stored in a text string? And is it even more weird like 300K, 2.5M? Tableau can show that in a table just as it is OR you can convert it to a number. I suggest 3 simple formulas to break it up, but there are many many ways to calculate this or put it into just a single formula.
➡️ Calculated Field Formula to Replace Letters with Zeros:
IIF CONTAINS([Followers], "M") THEN
REPLACE([Followers], "M", "000000")
ELSEIF CONTAINS([Followers], "K") THEN
REPLACE([Followers], "K", "000")
END
➡️ Calculated Field Formula to Remove Dots:
REPLACE([Followers Full Text of Number], ".", "")
➡️ Calculated Field Formula to Convert to Number:
INT([Followers no Dot])
🎥 Watch More 🎥
Tableau For Beginners: Basics You Need To Know
• Tableau For Beginners: Basics You Nee...
📢 Connect With Me 📢
🌐 Website: Thinkermetrics.com
🎧 Spotify: https://open.spotify.com/show/5m618Wf...
📷 Instagram: @thinkermetrics
🐦 Twitter: @thinkermetrics
📱 Facebook: / thinkermetrics
📧 For business inquiries: [email protected]
🎉 About Us! 🎉
Hey data enthusiasts! Dive into the world of analytics and Tableau with us. This channel is for newbies wanting to apply analytics to digital data. We'll explore social media analytics, search trends, and more. No boring store data here! Perfect for students, new professionals, designers, and business users. Less math, more visualization. Join us as we have fun with data and your personal data from apps you use!
#tableautips #dataanalytics #datavisualization #tableauformula
#functions
