Multiple Field Formula

[ebledsoe22]

Hello,

I am trying to use the Multiple Field Formula tool in order to add/subtract values in 3 rows together. I am working on an apportionment workflow where my first row is my gross unadjusted data and the two subsequent rows are adjustments that need to be added to the first row. How do I create my formula in the expression tool to get my desired result?

[FinnCharlton]

I think @BS_THE_ANALYST has suggested a good method, though I'd add that it might be worth thinking about transposing your data. In the long run it would be more useful to have your states as rows and your metrics as columns, as problems like this could then be dealt with in a single formula tool. It would probably also help with any further analysis.

[ebledsoe22]

@BS_THE_ANALYST Thank you for your response. I do have a record number column. The Gross inventory number is record number 1. The first adjustment is record number 1.1 and the second adjustment is record number 1.2. Is there an expression that I could build that could add them together using the record numbers?

[BS_THE_ANALYST]

@ebledsoe22 Sure thing. You can just use the filter tool here if you already have record IDs. We can set the filter criteria to only filter for the range for records between 1 and 1.2 in this case. This will extract those RecordIDs? See attached ..

[ShankerV · Accepted solution]

Hi @ebledsoe22 

One way of doing this,

Input was:

Output is:

Workflow:

Hope this helps!!!

If you need the workflow let me know, I will explain the steps in detail as I am unable to save the workflow to attach here.

Many thanks

Shanker V

[ebledsoe22]

Hello. This is related to my previous Topic. I have data in a row that I need to multiply by data in a column. Should I use the Multi-field tool for this or is there another way to do it?  See screenshot below. I need to multiply the ratio in row 2 by the amounts in the total column starting with row 3.

[ShankerV]

Hi @ebledsoe22 

One way of doing this.

Row 3 is multiplied with Row 3 total * with corresponding row 2 column value.

Hope it helps!!!!!

[ebledsoe22]

Hello. I am using the Multi-Row Formula again. I have 5 columns and 33 rows. I want to multiply the ratios in column 4 by the value in Column 2, row 32 only, but I can only get one row to do that before it starts to multiply my ratios by the subsequent row value. Is there a way for it to only multiply by that particular cell and not the one after it?? See snipet below. The first row of my allocated reserve column is correct. The rest are multiplying by the wrong number. How do I fix this?