Calculation for a column based on other row fields value.

[ajanayak]

Hello Team,

Please help me on my problem which I am facing for my exercise. Need to update a single column value of a row by taking other row fields value,

Everything related requirement is documented in the attachment in Input and Output sheets.

Any help would be highly appreciated.

Thanks

AJAY

[ShankerV]

Hi @ajanayak 

You can achieve the solution by below steps.

1. Use the record ID tool.

2. Use dynamic rename tool.

3. Use the Transpose. Multi row formula and then Crosstab back to ge the desired output.

Many thanks

Shanker V 

[ajanayak]

Thanks Shanker,

I tried few things based on our previous solution provided by you and team, but it seems bit difficult to capture the range of (Prior 2 column to next 3 columns), I feel great if you can provide the solution in a WF using the same data provided by me in the attachment.

Please consider my request.

Thanks

AJAY

[ShankerV]

Hi @ajanayak 

Working on it, few seconds please.

Happy to help!!!!

[ShankerV]

Hi @ajanayak 

Please find the expected output.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @ajanayak 

Step 1: Input 

Step 2: Record ID to keep the format till end

Many thanks

Shanker V

[ajanayak]

Hello Shanker,

The solution looks absolutely fine. Thanks for all your help in my learning days.

Thanks

AJAY