Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Fields value addition

Inactive User
Not applicable

Hi All,

 

I have below sample data:

 

F1  F2   F3............Fn

A     10     5.............Fn

B      20    10

C      30     26

D      15     8

 

What i want to achieve is to add A B for all fields and same for C D,e.g; sum of A B for F2=30 in single cell and so on. Can anyone help ?

4 REPLIES 4
Matt_D
9 - Comet

Hi @Inactive User I think you need the Running Total Tool

IraWatt
17 - Castor
17 - Castor

Hey @Inactive User,

Here is one way to do this for as many columns as you want:

IraWatt_0-1655292106995.png

Any questions or issues please ask :)
HTH!
Ira

 

grazitti_sapna
17 - Castor

@Inactive User, another way of getting the desired result.

 

grazitti_sapna_0-1655296118535.png

But you need to set the tile if the number of records increases. number of tiles=num of rows/2

grazitti_sapna_1-1655296242960.png

 

I hope this helps!

 

Thanks!

Sapna Gupta
ddiesel
13 - Pulsar
13 - Pulsar

Hi @Inactive User!

 

Did any of these solutions work for you?

Labels