SOLVED
Removing Nulls
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
romachainani
6 - Meteoroid
‎10-03-2023
02:45 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This is what I have:
Sum Values | Sum Sum Values |
[Null] | 3345 |
12345 | [Null] |
This is what I need:
Sum Values | Sum Sum Values |
12345 | 3345 |
I basically need to remove those nulls. It's a simple ask, but not sure why I can't get it right now. Ty for the help!!!
Solved! Go to Solution.
Labels:
- Labels:
- Help
2 REPLIES 2
Prometheus
12 - Quasar
‎10-03-2023
02:52 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@romachainani I used a Transpose tool to put all the values into one column -- Value. Then the Filter tool to not allow nulls to pass. Then finished with the Cross Tab tool to repivot the data.
 
 
 
binuacs
21 - Polaris
‎10-04-2023
08:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@romachainani Another option with the summaries tool