Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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