Operating in Multiple Row & Columns

Question

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.

AngelosPachis · Accepted Answer

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