Your calculations do look fine.
Please can you upload a workbook (pref clean data) so we can see where you have got to and where the problem appears to be.
You are missing an 'End' for calc a. Aging_Bucket and, you have a right parenthesis on each of your logic statements for ActualAging Bucket but I guess this is just a typo for the post.
When mocking this together in Superstore, (without the typos) everything seems fine. See attached.
212024 - Aging.twbx 1.2 MB
Thanks a lot Steve , the solution worked just as you mentioned. I forgot to convert the "AgingBucketTemp" into continuous and that stopped me in proceeding further.
Yes the END in the if statement was a typo while posting.