Count expression for diff fields...

[jmarinesc]

 
 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

[MayilVahanan]

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

[CELAMBARASAN]

With these conditions you will get only 2

Expression

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

[jmarinesc]

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

[MayilVahanan · Accepted solution]

HI

Try like this

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

[jmarinesc]

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

[MayilVahanan]

HI

Try like this

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