Need help in expression

[#1]

Dear Friends,

I am using QV 10 and in a pivot table i have written a expression like the following

=If([Statement Number]>1,Count([Transaction Reference]),0) but the total as well as partial sum shows as 0 only.

Is it possible to show the total of the expression.

Regards

Chriss

[#2]

use count(if.... instead of if(count

this will help

[#3]

Hello Arasu,

Thanks for your reply, I tried with count(If....), could you please help me further.

Regards

Chriss

[MayilVahanan · Accepted solution]

Hi,

     Try this,

     =Count({< [Statement Number] = {">1"} > } [Transaction Reference])

     Refer the data once, is there any "Transaction Reference" data is greater than 1 for statement number..

     Can you post a sample file..

     Hope it helps..

[#5]

try this:

If([Statement Number]>1 or rowno()=0,Count([Transaction Reference]),0)

[#6]

Hi,

Your expression works exactly...

Regards

Chriss