Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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
13 - Pulsar

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
11 - Bolide

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

FinnCharlton_0-1674672830149.png

 

binuacs
17 - Castor

@carterfleming One way of doing this

 

binuacs_0-1674682198910.png

 

carterfleming
8 - Asteroid

Thanks @binuacs this solution worked great!

Labels