Count fied from excel

Sun, 16 Dec 2012 17:51:46 GMT

Hi,

I have some data in the excel file where I need to count records who respect determinate condition.

To do so, I have created the following formule:

=count( {<Field1={3405}>} Field1) --> this formula it's OK!

=count( {<Field1<>{3433}>} Field1) --> This formula it's KO, why?

I want to count all records within the field1 which is different from 3433.

Can you please help me?

Regards

Re: Count fied from excel

Sun, 16 Dec 2012 18:30:04 GMT

use this:

count( {<Field1 -={3433}>} Field1)

Regards

Sun, 16 Dec 2012 18:44:51 GMT

Perfect!

Thank you