Alteryx Designer Desktop Discussions

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

Difference for multiple unstructured line items

Rafiuddin_333
7 - Meteor

Hello everyone,

 

I am a newbie exploring Alteryx and I have encountered a problem for which I need your help in solving. 

 

ParticularsCost (x)ProductsCost (Y)Variance (X)-(Y)
Item 12000A1001500
  B200 
  C100 
  D100 
Item 2500E150250
  F100 
Item 3100G5050

 

From the above table, for Item 1 which is linked to 4 products I need variance of Item 1 and sum of its products related to it I.e sum of A+B+C+D So 2000-(100+200+100+100)=1500.

Likewise for Item 2 its 2 products E & F so 500-sum(150+100)=250

With the above example is it possible i can get variance column in Alteryx that shows me the combined products with variance?? 

 

Thank you very much for your help!

Regards,
Radic

2 REPLIES 2
griffinwelsh
12 - Quasar

See the attached solution

flying008
15 - Aurora

Hi, @Rafiuddin_333 

 

FYI.

录制_2024_07_17_08_18_22_727.gif

Labels
Top Solution Authors