Need Help Adding a row into my data Set Based on a Calculation/Logic

MitchS

Hey Community,

I am just starting out using Alteryx and need some help with a problem I have.

I have the following columns in question:

Material Number

Accepted answers

grazitti_sapna

Hi @MitchS, is this what you are looking for?

I hope this helps!

Thanks!

Dummy WF MitchS.yxmd

All comments

Kottapally_Ramesh

Hi @MitchSewhoy

Please see the attached workflow which will give you Projected Closing Stock & if you need to rollout the data to next month add a filter & select only "Projected Closing Stock" row to get the result.

Hope this helps.

Dummy WF.yxmd

grazitti_sapna

Hi @MitchS, I have a query related to your desired output.

For the month of June 2022, you need projected closing stock= 20 which will be achieved using

Closing Stock is = to Opening Stock on hand(closing stock of the previous month except for August) + Demand + Production

But for the month of July 2022 you need

Closing Stock is = to Opening Stock on hand(closing stock of the previous month except for August) - Demand + Production

Are you calculating the month of June 2022 and July 2022 separately? Can you please clarify?

Thanks!

MitchS

Hey @Sapna Gupta

Sorry, Yes I would want June 22 Closing Stock to be calculated off the May 22 closing stock (June 22 Opening) - Demand (Sales) + Production and then have the same happen for July 22 but based on June 22 Closing Stock.

Forgive me for putting in bad example values which would give a Negative closing stock for June 22. For this, if we just change the May 22 closing stock number (which I have hard-coded but would want to be calculated as above) to say 20 and kept June 22 Demand as 10 and Production as 5. S Closing Stock for June 22 would then need to be 15.

Hopefully this helps,

Cheers,

Mitch.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703