We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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
‎03-14-2025 09:35 PM

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.

Preview file
18 KB
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
flying008
15 - Aurora
‎03-15-2025 12:01 AM

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
Reply
ThankForYourHelp
8 - Asteroid
‎03-15-2025 06:06 PM

Thank you

Reply
0 Likes
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All