Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Multiplying two rows

carterfleming
8 - Asteroid

I'm trying to add a function to my workflow that would multiply the sum total by a specific rate as shown in the screenshot. How would I go about this?

 

Note: the below screenshot is from my current workflow output. I'm good up until the point I need to multiply the first selected row by the second selected row.

 

carterfleming_0-1674672206264.png

 

4 REPLIES 4
ShankerV
17 - Castor

Hi @carterfleming 

 

There are multiple ways to achieve this.

 

One way is to split the data into two, last 2 rows and the remaining rows.

Do the Transpose and Multirow tool for multiplication and Crosstab.

 

You get the output. Join both dataset.

 

Many thanks

Shanker V

 

 

FinnCharlton
13 - Pulsar

Hi @carterfleming , here is a way to multiply two rows:

FinnCharlton_0-1674672830149.png

 

binuacs
20 - Arcturus

@carterfleming One way of doing this

 

binuacs_0-1674682198910.png

 

carterfleming
8 - Asteroid

Thanks @binuacs this solution worked great!

Labels