Multi-Row Formula

Hi SME,

I have a table with various Type values. I need them to be calculated based on the Type as indicated in the Excel file below. The result would be column D. Could you please help me understand how to use the Multi-Row Formula to get this presumably this is the most efficient to do this? I attempted to do it but it's long and cumbersome.

Thanks,

kwl

Example.xlsx

Workflow

Accepted answers

binu_acs

@knnwndlm one way of doing this, since you mentioned there is no specific logic I used the same logic in the given input to generate the output

sum_total_010423.yxmd

All comments

Felipe_Ribeir0

Hi @knnwndlm

Could you please explain better the logic behind this sum? For example, why the row 9 (DST3) was summed to make the DST group?

binu_acs

@knnwndlm I think find and replace is the best option here instead of the multi-row tool

Find_Replace_030123.yxmd

knnwndlm

Hi @Felipe_Ribeir0

There's really logic behind it except to present the info in a certain perspective for the users.

Thanks,

kwl

knnwndlm

Hi @binu_acs

The example is a simple one. The workflow I'm building is rather intricate. Could you please show me how to use the Multi-Row Formula tool to achieve the same results?

Thanks,

kwl

knnwndlm

Hi @binu_acs

The lower branch you showed is pre-calculated. My dataset has a lot variety of combination - hence, I need to figure some ways to use the Multi-Row Formula to add up the various records prior to join them back to the original dataset.

Thanks,

kwl

binu_acs

@knnwndlm Can you explain the logic behind each type? for eg: DST is the sum of all DST type + DST3 type

DST1 type + DST2 Type gives the value 1700, so if you can provide the logic we can see which tool would be helpful here

knnwndlm

Hi @binu_acs

There's no logic really. It's based on the past reports where people want to highlight certain aspect of the combined amounts based on the Type. I know that it's strange, but I'm trying to replicate past reports in a workflow. If you can show me how to grab and add the rows based on the Type, then I would be able to figure out the rest.

Thanks,

kwl

binu_acs

@knnwndlm one way of doing this, since you mentioned there is no specific logic I used the same logic in the given input to generate the output

sum_total_010423.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703