SOLVED
Conversion of data
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
EN6924
10 - Fireball
‎12-28-2021
08:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a daily backup related data. Please guide me to convert the values under column name "Data written" from size in TB/GB/MB/KB to a separate column and in only bytes.
Actually I wanted to sum all the values under "Data written" but values are in different size.
Solved! Go to Solution.
Labels:
- Labels:
- Tips and Tricks
3 REPLIES 3
r_manju02
8 - Asteroid
‎12-28-2021
08:26 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
binuacs
21 - Polaris
‎12-28-2021
10:38 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎12-29-2021
08:57 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Thanks for guiding me.
I already did it but that doesn't looks perfect to me.
1. I split the column into 2 parts.
2. Then created added a formula tool -
Found result -
3. Added a summarize tool and formula tool (convert the size from bytes to GB & TB)