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.
Haha while writing my reply @afv2688 already posted a solution! **bleep** ;-).