Multi-Row Formula with Various Inputs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am not sure if this is possible, but I have a Page Numbers field that could contain various numbers. I basically want to assign a number to each page number in increments of 5. The count of 5 would need to start from the first page number, no matter what it is The problem is that my data doesn't contain all page numbers in sequential order and page numbers could be duplicated. I also have different years and would want the 5 count to start over based on the year. I've attached two examples. This would be a lifesaver! Thanks!
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
you basically need to round each number to the nearest multple of 5, but how are you determining the rounding? up? down? closest?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I don't know how that would work because the page numbers will vary. Numbers that I want captured in the same group could be rounded to different numbers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @bsolove , let me know if I'm looking at this right, but I went about it by finding all possible page numbers (missing or not) and assigning a new page number for every 5th record. Once you have this for all possible page numbers, a join back to the original data will give you the renumbering for just the pages you need.
Image and workflow attached below
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NickSm I think this will work, but how would it work if I need to group it by years? See example 2 attached below.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@afv2688 I don't think your solution works in my example because page numbers are either missing or duplicated.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Slight modification that now groups by the years column by ticking the "Group-By" box in the multi-row formulas.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NickSm Thank you so much!
![](/skins/images/6056C79A596CAB15526D64C598622101/responsive_peak/images/icon_anonymous_message.png)