I have a table of formulations. The amount of each of 60 possible ingredients are listed in columns. Most of the formulations contain only 5-10 ingredients with the ingredient amount of all other columns being zero.
I would like to create a formulation column (without scripting) to count the number of non-zero ingredients.
The way I was thinking to do this is to sum conditional statements for each ingredient. This shows the first 4 ingredients:
![kpgallagher_ppg_0-1588779368026.png kpgallagher_ppg_0-1588779368026.png](https://community.jmp.com/t5/image/serverpage/image-id/23777iD5195228BF87756C/image-size/medium?v=v2&px=400)
Is there a quicker/easier way to do this without having to create a string of 60 if statements?
Kevin Gallagher