Multi-Row Formula
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
dreamlaurie
6 - Meteoroid
‎09-05-2024
06:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can I use the Multi-Row tool to find the next Account with a "0" in Doc 2/Doc 3? I want to apply some math between Account 123 and Account 999 with the zeros several rows down.
Labels:
- Labels:
- Developer Tools
- Workflow
3 REPLIES 3
OTrieger
12 - Quasar
‎09-05-2024
06:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@dreamlaurie
Of course that you can do it.
There are several options,:
1. you can define the rows +1 +2 +3 +4 etc. or -1 -2 -3 -4 etc.
Or you can filter out the row in between and then do the usual away with +1 or -1
griffinwelsh
12 - Quasar
‎09-05-2024
06:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not sure if I understand your goal, but this configuration will increase the new field number by 1 each time Doc 2 = 0 or Doc 3 = 0.
‎09-05-2024
07:24 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
How do I filter out the rows in between? For each set of data like this, I don't know how many rows will be between the 123 and the 999 with the zeros. Thanks