Start a new workflow:

[ankit0412]

Hi Community,

I am new to Alteryx and want to create a workflow and below are the formulas needed but I am not sure how to start this.

Need to calculate EOH and then WOS with below Data

Marketing_Name	Account	Plan	Category	WK01	WK02	WK03	WK04	WK05	WK06
Total	Total	202412	S/I	43	40	40	66	48	74
Total	Total	202412	S/O	58	57	53	55	56	58
Total	Total	202412	EOH	406	388	375	387	379	395
Total	Total	202412	WOS	7.4	7.2	7	7.1	6.9	6.5

WK02 EOH = WK01 EOH + WK02 S/I - WK02 S/O

WK03 EOH = WK02 EOH + WK03 S/I - WK03 S/O and So On…

and

WK02 WOS = WK02 EOH / AVG S/O (WK03, WK04, WK05, WK06)

WK03 WOS = WK03 EOH / AVG S/O (WK04, WK05, WK06, WK07) and So On…

Can you please guide me how to proceed

Thank you

[vishtrack]

Hi- Have you tried using Multifield formula? 

[ankit0412]

Hi Vish,
I tried it and it didn't work out for me, specially the WOS Average part, or maybe I am putting wrong formula in multi field formula tool

[Qiu]

@ankit0412 
Is it correct to understand the last 2 rows are actually the expected result?

If yes, then how did you calculate the "WK01 EOH"?

[ankit0412]

Hi Qiu,
1. Yes, after the calculation last two rows #s should be similar,
2. WK01 I added as an example lets say Actual # and starting WK02 are projected numbers, based on previous Weeks

Regards

[flying008]

Hi, @ankit0412 

The solution that is difficult to reproduce, just for reference, looking forward to other people's ideas.