SOLVED
How to create an aggregate column (Current line till the last line of the table)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
tal_il
7 - Meteor
‎04-22-2020
03:47 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi
I have a cash flow serious which I calculate their present value (colum "PMT PV")
I want to sum all the values from the current line till the last line of the table.
(I attached my spreadsheet as an example so you can see the formulas under the column "Liability")
Thanks, Tal
Solved! Go to Solution.
Labels:
- Labels:
- Help
- Tips and Tricks
3 REPLIES 3
17 - Castor
‎04-22-2020
03:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Would it work if you add a recordID, sort descending order, add running total, and sort ascending order?
17 - Castor
‎04-22-2020
04:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎04-22-2020
04:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The running tool is new to me
let me check 🙂
Thanks!
