Calculating % Difference From Previous Week

[jkv0019]

Hello Everyone,

I am new to Alteryx and was wondering if I could ask for help with a workflow I have. 

I pull from SQL Server to get the orders we have processed from each supplier. I have put together a workflow that gives me a base for what I would like to accomplish. However, I'm stumped by how to add a column in that calculates the difference in orders between Column A and Column B, B being the following week and will be dynamic as more weeks are added.

Also, I am having a little trouble with returning the correct week number, as you can see below (2021-00). I used DateTimeFormat([Act Arr CST],"%Y") +'-'+ DateTimeFormat([Act Arr CST],"%W").

If anyone has any suggestions, can you please provide them?

[Qiu]

@jkv0019 

I believe this is as per design.

---

%W	This returns the week number, as 00 – 53, with the beginning of weeks as Monday

---

We can make it as starting from 01 though.