Hi,
I'm looking for a way to add rows which contain formulas, where the Formula Tool only allows the addition of columns.
In the example, I have two types of formulas which need to be added:
1). A6 = A5 / A4
2). A9 = A4 + A11 + A12
I'm hoping that this is a minor adjustment, as the entire workflow is already built out and working properly. I'm looking for something that can aggregate the final pieces of data without requiring a substantial portion of the workflow to be rebuilt.
Thank you!
Tough to say with the small sample and not knowing what else your workflow is doing.
You could play around with the Multi-Row Formula to do math between rows but it won't do what you're asking by itself.
A better option might be to Crosstab your data into columns so you can use the Formula and then Transpose it back into rows.
-Scott