SOLVED
Iterative subtraction
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
Guglielmo91
6 - Meteoroid
‎11-16-2021
02:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi there I have a problem that you guys/girls may be able to solve
i have the following input (see the attached excel), in the second sheet you can find what i would like to obtain in alteryx
Just for sake of clarity i generally have for each work center 2 columns, Capacity and Workload. I would like to add a third one that makes the difference of the two >> Delta = Workload - Capacity
ASSIEME ROTORE - Capacity | 244 | 266 | 302 | 244 | 290 | 248 | 254 | 160 | 284 | 270 | 274 | 198 |
ASSIEME ROTORE - Workload | 717 | 642 | 874 | 483 | 573 | 591 | 379 | 456 | 379 | 512 | 604 | 752 |
ASSIEME ROTORE - Delta | 473 | 376 | 572 | 239 | 283 | 343 | 125 | 296 | 95 | 242 | 330 | 554 |
this for every work center till the end of the sheet. Many thanks.
Guglielmo
Solved! Go to Solution.
Labels:
3 REPLIES 3
afv2688
16 - Nebula
‎11-16-2021
03:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastiaandb
12 - Quasar
‎11-16-2021
03:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Sebastiaandb
12 - Quasar
‎11-16-2021
03:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Haha while writing my reply @afv2688 already posted a solution! **bleep** ;-).