Multi Row Formula help
- 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
Hi,
I have the following multi row formula, it creates a column named select and assigns it a 1 where my conditions are met. 0 for no conditions met.
if left([CMB SERIES NUMBER],4) = 'CHT1' || [CMB SERIES NUMBER] = 'Total'
then 1
else 0
endif
However I only want to do it up unti my FIRST total. I have two Totals in my SERIES column. How can I get my assiging of 1 to stop after my first Total?
Problem is I have many CHT1 below my FIRST Total that i want to exclude.
Solved! Go to Solution.
- Labels:
- Custom Tools
- 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
Still getting everything below the Total.
Seems like your filter is getting the 2nd total in this column. Not the First.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The red arrow on the total row indicates that there is leading or trailing white space on that cell. The filter was set to = "Total" so that will fail on that cell. Update the filter formula to be
trim([CMB SERIES NUMBER]) = "Total" and it should work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator