hello! I need to count only the data> 0 ente...

expressions
(Ballve Rosario Maria) #1

hello!

I need to count only the data> 0 entered in several columns. How do I put the condition “> 0” in this expression?

= COUNT (LIST ([P1], [P2], [P3], [P4], [P5], [P6], [P7], [P8], [P9], [P10], [P11], [ P12], [P13], [P14], [P15]))

thanks!

(Tony Fader) #2

@Ballve_Rosario_Maria You’re going to need to do something like this:

IF([P1] > 0, 1, 0) + IF([P2] > 0, 1, 0) + … + IF([P15] > 0, 1, 0)

Generally speaking, having a lot of columns like that is a bad idea. It’d be better if you created another table that has a reference column, then you can use a COUNT(SELECT(…)) expression.

(Tony Fader) #3

https://help.appsheet.com/data/references/references-between-tables

(Aleksi Alkio) #4

IFS([P1]>0,1)+… would help a little :slight_smile:

(Ballve Rosario Maria) #5

thank you very much