This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have to get a calculated stock value, for a stocks report.
Im doing it in excel, but im just trying alteryx like a new tool for me and i would like to automatize this processs with alteryx.
I couldnt get it , maybe somebody can helpme here.
Here we are :
Im Using this common formula : Initial Stock + Purchases - Sales = Final Stock Then , the final stock in one month must be the initial stock for the next month, and here is where i have the problem.
I have 3 bases o 3 dates : -Initial Stocks -Purchases (Sell In) -Sales (sell out)
Im doing it in excel :
First Month Initial Stock : is date by VLOOKUP , only for the first month in the base Purchases : is date by VLOOKUP Sales : is date by VLOOKUP Final Stock : Initial Stock + Purchases - Sales Initial Stock: Final stock value of previous month I use a vlookup of concatenate Month-1+client+Product
Using alteryx i cant elimite the "VLOOKUP" proces using the "union tool"
but how do correctly that the initial stock have to be the final stock of previous month in alteryx and get an flat base?
Thank you Ben , i already changed the format to number, buy anyway is not working the row formula. i mean, i cant see values in the "stock inicial 2" created in the row formula and the "stock Final" at the end.