Can we calculate the formula using conditions for multiple rows?

[AYESHASIDIKHA]

Hi Team,

I have a doubt, The data I am working on is based on Years and Amounts. Attaching one sample excel file which has dummy data

The condition is like for example,

If we are taking 2023A column then the formula for first and last years(2023,2025) is Amount/2*0.5 and for the middle year(2024)  is   Amount/2.

If we are taking 2023B column then the formula for first and last years(2023,2028) is Amount/5*0.5 and for the middle years (2024,2025,2026,2027)  is   Amount/5.

It would be great if i get a solution ASAP.

[AYESHASIDIKHA]

Hi,

I am getting this Error which is attached.

[ed_hayter]

Can you show your configuration for the generate rows tool. My workflow runs fine so just want to check the configuration is the same.

Alternatively if you've switched the input file to another file it might not be working as intended

[AYESHASIDIKHA]

Attaching the screenshot of configuration window

[ed_hayter]

that all looks ok - except you have an extra record going into the generate rows compared to me which would suggest something earlier in the flow has changed.

In my input i have the first row contains data is unchecked.

I believe this is causing the field names to be different.