Displaying Numbers In a Range
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi All,
I have been working with ranges and hit a snag. I have played with the generate rows tool to try this but it isn't working for my data set or I am just not using it right. Below is my dataset. The MS-DRG columns are the range that I split out.
DX | MDC | MS-DRG | MS-DRG1 |
A000 | 06 | 371 | 373 |
A001 | 06 | 371 | 373 |
A009 | 06 | 371 | 373 |
I would like to add another column or multiple columns to display the numbers that are missing. For example, below is what I want. I do have some that show a larger range.
DX | MDC | MS-DRG | MS-DRG1 | MSDRG2 |
A000 | 06 | 371 | 372 | 373 |
Any assistance is much appreciated!
Best,
Bryan
Solved! Go to Solution.
- Labels:
- Tips and Tricks
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I've attached a workflow that shows how this can be achieved. It's probably a little over-complicated, but it's solid. Also it names the MS-DRG fields starting with 1 rather than empty, I hope that's ok. I can fixed that if it's an issue.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CharlieS Thank you soo much. I used the generate row tool and figured that out as well. Yours works better for the columns names. Thanks again.