nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Multi-Row Subtraction

KmbrlyPC

What multi-row formula can I use to subtract every other row from the one before it? The result column is what I need. For example, Value 8-6=2, Value 4-3=1, Value 2-6=-4

Set	Value	Result
1.2	6
1.6	8	2
1.2	3
1.6	4	1
1.2	6
1.6	2	-4
1.2	6
1.6	8	2
1.2	3
1.6	5	2
1.2	7
1.6	4	-3

Expression

Accepted answers

atcodedog05

Hi @KmbrlyPC

Your multi-row formula tool formula would be like below.

Workflow:

Hope this helps : )

multi-row formula.yxmd

DawnDuong

hi @KmbrlyPC

Not sure why you have that error. My workflow runs perfectly though. Perhaps you can check if your datatype is correctly set - if not some logic test (e.g. 😃 may fails.

Attached the workflow here.

ForKim.yxmd

All comments

atcodedog05

Hi @KmbrlyPC

Your multi-row formula tool formula would be like below.

Workflow:

Hope this helps : )

multi-row formula.yxmd

DawnDuong

hi @KmbrlyPC

The Multi-Row formula tool is what you need. If you have not used this one before, you can rightclick on the Multi-Row tool to open the example workflow and learn the various settings from there.

Check out the full Help documentation at: https://help.alteryx.com/20213/designer/multi-row-formula-tool

Dawn.

KmbrlyPC

Unfortunately, it is not working. All it's doing is repeating the value in the active row. So for example, on Row 2 instead of the Result being "2" it is showing up as an "8". I used the formula exactly.

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15911

binu_acs 15783

MarqueeCrew 13710

apathetichell 13703