Count if condition

[#1]

Hello,

I'm trying to count different rows in a database where a field's value is different from 1.

For example, a quote can have 6 different values from 0 to 6 (accpeted, refused, pending, etc) and I need to count the amount of quotes that are not accpeted, that is to say, they can be pending, refused, ...

I already succeeded counting the amount of quotes that are refused, using:

count ({<ENDV_NVARIANT={0}>} ENDV_NVARIANT) which works perfectly,

but when I replace the "=" by "<>" in order to have a condition where it has to be different from "1", it doesn't work since the symbols are interfering.

count ({<ENDV_NVARIANT<>{1}>} ENDV_NVARIANT)

Is there another way to do this?

Thanks a lot!

[MK_QSL · Accepted solution]

count ({<ENDV_NVARIANT -= {1}>} ENDV_NVARIANT)

[#3]

When I introduce your expression, it tells me there is an error 😕

[#4]

On the other side, the other expression:

Count({<ENDV_STATUT_DE_SUIVI = {"<>1"}>} ENDV_STATUT_DE_SUIVI)    (the variables are the same, sorry for the change)

seemed to work, but it doesn't take into accoun the quotes with value "0"

[MK_QSL]

When we use -= in Set Analysis, it will give you syntax error (Red Lines) but the formula will work..

Just ignore the syntax error while using -=