Compounding Numbers from Previous Row

Hello,
I have read through a few posts on referencing the above row and can't seem to get anywhere. I need to compound the % of the total revenue from the row above so eventually I will reach 100%:
Does anyone have any ideas on how to achieve this? Thanks!
Answers
-
Does this work for what you need?
=1 - (Amount@row / Total#)
-
I can't get that to work either. The formula I have in there works for this version but the sheet is on a Data Shuttle that rows will change slightly when imported and when a row gets deleted it gives an error instead of just referencing the new data that is in the hard coded row. @Paul Newcome
-
In my above formula, there is no hard coded row number. What exactly do you mean you can't get it to work? Are you getting an error message ro an unexpected output?
-
When I put in your suggestion it was just giving me the percentage of each row, but I need the percentage to be a cumulative based on the row above it. So the first row is 6% of the total and then row two is 2% of the total so the %Revenue cell for row 2 should be 8%, and so on. It works perfectly when I import the data and write the formula, but when I delete a row or the data shuttle runs I get an #UNPARSABLE starting at the row that was deleted or changed. Sorry if this does not make sense, I'm trying my best to explain.
-
Did you do the "one minus" at the beginning of my formula and then apply as a column formula? The below screenshot is basically what you are looking for, right?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!