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.
Solved! Go to Solution.
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
Thanks @binuacs this solution worked great!