Multiplying two rows

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.

Preparation

Accepted answers

@carterfleming One way of doing this

MultiPlying_Row_012523.yxzp

All comments

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

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

Multiply rows.yxmd

@carterfleming One way of doing this

MultiPlying_Row_012523.yxzp

Thanks @binu_acs this solution worked great!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703