Hi guys, first of all I wanna thank you for your help, cause this forum helps me every time I'm stuck in something.
But now I have a problem and I need to bother you with it! MAYBE you can help me.
I need to proyect my stock in one of my reports and I can't do it cause IDK how to operate using diferents columns and rows at the same time.
I will try to explain my self, please be patient with me, cause English is not my first language.
For example: in this table I have the first value in January, so my first calculation is:
January final stock: Inicial stock + Brought in products + Local sales, so the result is 1.042.
but for February is: January Result (1042)+ February Result (181) : 1.223
For March: January Result (1042) + February Result (181) + March Result (181): 1.404 and so on.
I manage to do something like this with my data in alteryx:
And I know that using "Multiple-Row Formula" I can do operations from diferent rows, like using "ROW-1"+"CURRENT ROW" but I need to do something like this:
For the first result:
And for the next ones:
Do you have any idea how to do it?
Thank you all for your help and again, sorry for my language.
Emmanuel.
Solved! Go to Solution.
Hi @emmanuel_gentile ,
I think you're heading down the right path. Your multirow formula tool should have an expressions similar to
IF ISNULL([Row-1:result]) THEN [Projection]
ELSE [Row-1:result]+[Projection]
ENDIF
which translates as:
If I don't have a value in my above row (so the month is January, keep the value in the projection column, else get the value in the projection column and add it to the value in the above row.
There is another way to achieve the same result, using a running total tool
Hope that helps, let me know if you have any questions.
Cheers,
Angelos
Thank you Angelos!! It worked perfectly fine!
thanks!!!