In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Iterative subtraction

Guglielmo91
6 - Meteoroid

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 - Capacity244266302244290248254160284270274198
ASSIEME ROTORE - Workload717642874483573591379456379512604752
ASSIEME ROTORE  - Delta47337657223928334312529695242330554

 

this for every work center till the end of the sheet. Many thanks. 

 

Guglielmo 

 

3 REPLIES 3
afv2688
16 - Nebula
16 - Nebula

Hello @Guglielmo91 ,

 

Think I got what you are looking for

 

Untitled.png

 

Regards

Sebastiaandb
12 - Quasar

@Guglielmo91 Here you go!

 

Sebastiaandb_0-1637061195423.png

 

Greetings,

 

Seb

Sebastiaandb
12 - Quasar

Haha while writing my reply @afv2688 already posted a solution! **bleep** ;-). 

Labels
Top Solution Authors