Difference for multiple unstructured line items
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Rafiuddin_333
7 - Meteor
‎07-15-2024
11:18 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I am a newbie exploring Alteryx and I have encountered a problem for which I need your help in solving.
Particulars | Cost (x) | Products | Cost (Y) | Variance (X)-(Y) |
Item 1 | 2000 | A | 100 | 1500 |
B | 200 | |||
C | 100 | |||
D | 100 | |||
Item 2 | 500 | E | 150 | 250 |
F | 100 | |||
Item 3 | 100 | G | 50 | 50 |
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
Labels:
- Labels:
- Designer Cloud
2 REPLIES 2
griffinwelsh
12 - Quasar
‎07-16-2024
11:48 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
flying008
15 - Aurora
‎07-16-2024
05:19 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
