Multiplying records, similar to Sum in Summarize tool

Afrooz

Hi everyone

I am trying to Multiply one column values together similar to sum in summarize tool.

for example. [Field] = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and I want to multiply them together.

would be great if someone could help me with this.

Thanks

Afrooz

Preparation

Accepted answers

All comments

ponraj

Here is the sample workflow. Hope this is helpful.

Multiplying records - similar to Sum in Summarize tool.yxmd

Afrooz

Hi @ponraj

Thanks for your solution.

I need to group by date column and ID so I need to to have the result of the multiplication to be a column and not only one records. this workflow gives me only one record.

Many thanks

Afrooz

neilgallen

On a mobile so unable to mock up a workflow but....

add a tile tool set to unique value, with your grouping fields as the unique values. To be safe, check the “leave unsorted” option.

the tile field will create two new fields, one tile number and one sequence. This becomes important later.

then use a multi row formula tool. Check the fields you want as your grouping (or use the newly created tile number). Set Missing rows to be null.

your formula would be something like (excuse the syntax):

if isnull([row-1:field]) then 1*[row 0: field] else [row-1:new field]*[row 0: field] endif

then sort on your tile number, ascending and tile sequence number descending.

a sample tool will let you choose a grouping field and take the first row per group. This is done in case your values have a negative.

i *think* that gets you there.

Afrooz

Hi @neilgallen

Thanks for your response.

I'm not sure which part I'm doing wrong but it doesn't give me the answer.

would be great if you could give me a sample workflow when you get a chance.

Many Thanks,

Afrooz

patrick_digan

@Afrooz you may want to like my idea here about adding a "product" to the summarize tool.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703