Is it possible to create a new column with a formula referencing the row below?
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
CDIns
8 - Asteroid
‎10-11-2024
06:25 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I need to add a formula to my dataset, however, I need to reference the record below. Example would be creating a new column in row 1 that is using the value in row 2 to calculate the change? Sorry if this has been answered already.
Labels:
- Labels:
- Common Use Cases
- Datasets
- Preparation
3 REPLIES 3
OTrieger
13 - Pulsar
‎10-11-2024
06:28 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@CDIns
You should be able to do it with a Multi Row Formula tool
‎10-11-2024
06:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks for the heads up! I will give that a shot.
OTrieger
13 - Pulsar
‎10-11-2024
06:38 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Cool
