6 Replies Latest reply: Dec 4, 2012 11:33 AM by Jaime Marines

# Count expression for diff fields...

```
Hello QVComm....
```

I am using below expression :

COUNT({<ESNOMATCH={'-1'},ESNOMATCH1={'-1'},ESNOMATCH2={'-1'}>} ESremision)

Using Expr in Pivot Table, How can I Count ESremision (9) with these conditions.........Tk in advanced.

 ESremision ESNOMATCH ESNOMATCH1 ESNOMATCH2 37 76 -1 77 -1 -1 155 -1 -1 167 -1 -1 174 -1 -1 -1 228 -1 -1 -1 321 -1 -1 387 -1 -1 Count = 9

JMC

• ###### Re: Count expression for diff fields...

HI

Try like this

=Sum(Aggr(1,ESremision)) in title/ caption

or

In expression, rowno() and in expression tab, change the total mode as numeric count of rows in dropdown list

hope it helps

• ###### Re: Count expression for diff fields...

With these conditions you will get only 2

Expression

COUNT({<ESNOMATCH={-1},ESNOMATCH1={-1},ESNOMATCH2={-1}>} ESremision)

• ###### Re: Count expression for diff fields...

Hello!

I try this expr....and I get :  Error in set modifier ad hoc element list.....

count({<ESNOMATCH={-1}>+<ESNOMATCH1={-1}>+<ESNOMATCH2={-1}>} ESremision)

JMC

• ###### Re: Count expression for diff fields...

HI

Try like this

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1={'-1'}>+<ESNOMATCH2={'-1'}>} ESremision)

• ###### Re: Count expression for diff fields...

Great!

Expr OK

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1={'-1'}>+<ESNOMATCH2={'-1'}>} ESremision)

• Mayil.....IF I need Count like:

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1<>{'-1'}>+<ESNOMATCH2<>{'-1'}>} ESremision)

I get: Error in set modifier expr

JMC

• ###### Re: Count expression for diff fields...

HI

Try like this

count({<ESNOMATCH={'-1'}>+<ESNOMATCH1-={'-1'}>+<ESNOMATCH2-={'-1'}>} ESremision)