Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

ALTERYX SALES USE CASE

Rhitik_Krishnani
8 - Asteroid

Hello Community,

 

I hope you all are doing well.

 

Current SFO.PNG

Current SFO.PNG

The image above shows my current output capturing info about the required finished goods (FG), the raw material required for them (RM_reqd), I have calculated the number of FG possible and the FG balance after fulfillment of the order.

 

Desired SFO.PNG

The current scenario doesn't satisfy partial deliveries like in Row 2, required FG is 5 but 4 are possible. So, RM final should be updated to 11 and FG balance should be 0. Similarly for the 3rd row, RM available should be 11.. in the format above.

 

Please help me get this output.

If you face any difficulty in understanding the use case, please let me know.

 

~Thank You

Rhitik Krishnani

 

1 REPLY 1
danilang
19 - Altair
19 - Altair

Hi @Rhitik_Krishnani 

 

Here's a solution using a single formula tool

danilang_1-1636896736998.png

 

It just uses the Floor() function to determine if the amount available can satisfy the current requirements to calculate all the fields from [FG Possible] onwards

 

danilang_2-1636896864468.png

In future, please attach your sample data as a file or a text table and not an image.  Since I had to type in all the data from an image, my field names and non-essential fields like FG Code and RM Code don't match yours.

 

Dan 

 

 

Labels
Top Solution Authors