Generate Rows Tool - Adding a Total Row

[ebledsoe22]

Hello,

I am trying to add a total row to my data using the generate rows tool. Can this be done? Below is a screenshot of my data. I need the total to include all values with name that includes "Sum_". I think this is possible, but I think my loop expression needs some help. 

[martinding]

Hi @ebledsoe22 ,

Is there any particular reason why you need to use the generate rows tool to calculate the row total?

You could try the following approach too.

 

[blingen · Accepted solution]

Hi @ebledsoe22 --

Please see attached workflow, one way to attack it! 

[blingen]

Oops--read it as column, not row! 

[binuacs]

@ebledsoe22 One way of doing this

[ebledsoe22]

My Ultimate goal is to sum the "Sum_" rows so that I can get a percentage of the total and then multiply those percentages by the value in row "A".

[ebledsoe22]

Hi @blingen Thank you for this solution. This was actually very helpful because now I can create a ratio and then multiply by the correct cell using the multiple row formula tool.