Start a new workflow:

Question

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

202412

S/I

43

40

66

48

74

Total

202412

S/O

58

57

53

55

56

58

Total

202412

EOH

406

388

375

387

379

395

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

flying008 · Answer

Hi, @ankit0412

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

ankit0412 · Answer

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

Qiu · Answer

@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"?