Add Amount in Specific Cell of Column

[Srawat]

Hi,

I have some duplicate name and want to add figure appearing in front type 4 in final figure column.

Thanks,

Rajeev

[atcodedog05]

Hi @Srawat 

Your numbers don't seem to match. How is E4+D7=60? 

Is there any specific logic pattern this follows?

[Srawat]

Sorry for the confusion, Please refer correct screen shot.

[Srawat]

Correct one.

[atcodedog05 · Accepted solution]

Hi @Srawat 

Your expected numbers are still not exactly correct. But I think I got a fair idea of the expected logic. Whenever a name is repeated, you want to add the below row figure to the current final figure. This can be achieved by using Multi-row formula. Multi-row formula allows you to add cells from different rows provided they follow a fixed logic pattern.

Here is a link to Multi-row formula interactive lesson: https://community.alteryx.com/t5/Interactive-Lessons/Multi-Row-Formula/ta-p/82872

Try building it yourself. You can refer to my solution if you get stuck.

Spoiler

Hope this helps : )

[Srawat]

Thanks the Workflow is useful. 

However If I doesn't have "s.no."  and duplicate names in different row then how I can resolve the issue. As given in screen below. Please advise.

Thanks,

[atcodedog05]

Hi @Srawat 

It should still work with a small change. 

1. Add Record ID tool to simulate Sr.No

Groupby option of Multi-row formula tool will bring together the names even if its apart.

Hope this helps : )