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