Multi Row Formula help
- Suscribirse a un feed RSS
- Marcar tema como nuevo
- Marcar tema como leído
- Flotar este Tema para el usuario actual
- Favorito
- Suscribir
- Silenciar
- Página de impresión sencilla
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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.
¡Resuelto! Ir a solución.
- Etiquetas:
- Custom Tools
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
Still getting everything below the Total.
Seems like your filter is getting the 2nd total in this column. Not the First.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador
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.
- Marcar como nuevo
- Favorito
- Suscribir
- Silenciar
- Suscribirse a un feed RSS
- Resaltar
- Imprimir
- Notificar al moderador