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