Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Incremental row until different category

ThankForYourHelp
8 - Asteroid

Hi there,

 

I have an issue below that idk how to figure out. thank you for your help.

 

TaskMoneycostYearStart dateEnd of dateCummulative Amount
test 150000821.835616420211/1/20213/31/2021821.8356164
test 150000830.967123320211/1/20216/30/20211652.80274
test 150000840.098630120211/1/20219/30/20212492.90137
test 150000840.098630120211/1/202112/31/20213333
test 1500002204.23287720221/1/20216/30/20225537.232877
test 1500002240.76712320221/1/202112/31/20227778
test 150000148120231/1/202112/31/20239259
test 15000074120241/1/202112/31/202410000
test 150000020251/1/202112/31/202510000
test 150000020261/1/202112/31/202610000
test 150000020271/1/202112/31/202710000
test 150000020281/1/202112/31/202810000
test 150000020291/1/202112/31/202910000
test 250000125020211/1/20213/31/20211250
test 250000416.666666720211/1/20216/30/20211666.666667
test 250000416.666666720211/1/20219/30/20212083.333333
test 250000416.666666720211/1/202112/31/20212500
test 250000125020221/1/20216/30/20223750
test 250000125020221/1/202112/31/20225000
test 250000250020231/1/202112/31/20237500
test 250000250020241/1/202112/31/202410000
test 250000020251/1/202112/31/202510000
test 250000020261/1/202112/31/202610000
test 250000020271/1/202112/31/202710000
test 250000020281/1/202112/31/202810000
test 250000020291/1/202112/31/202910000

 

that Cumulative Amount column should add up that cost column.

 

please see formula in the excel for that cumulative amount column. data in Task column is different. so, cumulative amount for test 2 should not include test 1.

 

thank you for your help.

2 REPLIES 2
flying008
15 - Aurora

Hi, @ThankForYourHelp 

 

FYI.

 

录制_2025_03_15_15_00_07_345.gif

 

Output      
TaskMoneycostYearStart dateEnd of dateCummulative Amount
test 150000821.835616420212021-1-12021-3-31821.8356164
test 150000830.967123320212021-1-12021-6-301652.80274
test 150000840.098630120212021-1-12021-9-302492.90137
test 150000840.098630120212021-1-12021-12-313333
test 1500002204.23287720222021-1-12022-6-305537.232877
test 1500002240.76712320222021-1-12022-12-317778
test 150000148120232021-1-12023-12-319259
test 15000074120242021-1-12024-12-3110000
test 150000020252021-1-12025-12-3110000
test 150000020262021-1-12026-12-3110000
test 150000020272021-1-12027-12-3110000
test 150000020282021-1-12028-12-3110000
test 150000020292021-1-12029-12-3110000
test 250000125020212021-1-12021-3-311250
test 250000416.666666720212021-1-12021-6-301666.666667
test 250000416.666666720212021-1-12021-9-302083.333333
test 250000416.666666720212021-1-12021-12-312500
test 250000125020222021-1-12022-6-303750
test 250000125020222021-1-12022-12-315000
test 250000250020232021-1-12023-12-317500
test 250000250020242021-1-12024-12-3110000
test 250000020252021-1-12025-12-3110000
test 250000020262021-1-12026-12-3110000
test 250000020272021-1-12027-12-3110000
test 250000020282021-1-12028-12-3110000
test 250000020292021-1-12029-12-3110000
ThankForYourHelp
8 - Asteroid

Thank you

Labels
Top Solution Authors