Simple SUM() in Alteryx

Hello comunity!

I want to re apply this Excel formula in Alteryx:

As you can see in the formula bar, I need to do this: SUM(D17:D27) in cell E22, and in E24 it will be SUM(D18:D28) and so on and so on. In Excel is easy because I just need to drop down the formula and it changes accordingly (updating the cell values).

How can I reapply this in Alteryx? Is a column with a lot of rows, so I need a solution that I can reapply, not just for a couple of scenarios.

Thanks!

Workflow

Tips and Tricks

Macros

Accepted answers

All comments

AdwaitTarudkar

Have you tried Multi-Row Formula tool?

karla_camacho

Yes, but I have to do something like this:

And they are a lot of columns for me to insert 1 by 1.

karla_camacho

No, it´s not working. And for other columns I have to do it for up to 100 rows

AdwaitTarudkar

I guess the constant value might be causing the issue.

I am looking for another workaround meanwhile. I'll let you know if I come across something.

AdwaitTarudkar

1. Try and create a column for the constant value ( in your case- $C$10)

2. A good workaround would be using running total tool first on the target column and then apply multiple-row formula tool to achieve SUMA(D17:D27) (This way you can get rid of adding multiple rows manually) = [Row+6:RunTot_demand]- [Row-6:RunTot_demand]

3. Apply 2nd multiple-row tool to achieve the numerator of the formula i.e. D16+D28+ 2* SUMA(D17:D27)

4. Apply the basic formula tool to achieve D16+D28+ 2* SUMA(D17:D27) / (2 * $C$10)

Hope this helps!

binu_acs

@karla_camacho This can be achieved in different ways. If you can provide a sample input data and expected output in an excel file someone can help you with this.

Christina_H

I agree with @AdwaitTarudkar that a running total is the way to go. After generating a running total on your Demanda column, I've used this formula which I think matches yours:

(2*([Row+5:RunTot_Demanda]-[Row-6:RunTot_Demanda])+[Row+6:Demanda]+[Row-6:Demanda])/24

The exception is the value in C10. Working backwards from the one value I can see the data for I think it's 12, hence the /24 at the end (2*12). If you could append this value from a separate input so it's on every row it would be easy to incorporate in the formula.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703