Can we calculate the formula using conditions for multiple rows?

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.

Sample_Amount.xlsx

Date Time

Preparation

Behavior Analysis

Accepted answers

Gawa

hi @AYESHASIDIKHA

Please find attached workflow to realize your demand, I understand that you want to calculate in different logic depending on A or B.

If this is OK for you, please accept my post as a solution.

Can we calculate the formula using conditions for multiple rows_gawa.yxzp

ed_hayter

Ive added row totals to my packaged workflow by transposing the data columns summarizing and joining back on to the correct year

Conditional Calc.yxzp

All comments

Gawa

hi @AYESHASIDIKHA

Please find attached workflow to realize your demand, I understand that you want to calculate in different logic depending on A or B.

If this is OK for you, please accept my post as a solution.

Can we calculate the formula using conditions for multiple rows_gawa.yxzp

ed_hayter

Assuming that your input file had what you wanted the expected output to be like and you only have the year method combo and amount i went about reshaping it as follows

Its a combination of pivots and generating the amount of rows for the period depending on the methodology.

Conditional Calc.yxzp

AYESHASIDIKHA

Hey https://community.alteryx.com/t5/user/viewprofilepage/user-id/177620

Thank you so much for the quick response. But I need the total formula as well. Could you please help me on that?

ed_hayter

Ive added row totals to my packaged workflow by transposing the data columns summarizing and joining back on to the correct year

Conditional Calc.yxzp

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

Configuration_Generaterows.GIF

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703