Multiplying two rows

[carterfleming]

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.

[ShankerV]

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]

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

[binu_acs · Accepted solution]

@carterfleming One way of doing this

[carterfleming]

Thanks @binu_acs this solution worked great!