Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
use count(if.... instead of if(count
this will help
Hello Arasu,
Thanks for your reply, I tried with count(If....), could you please help me further.
Regards
Chriss
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..
try this:
If([Statement Number]>1 or rowno()=0,Count([Transaction Reference]),0)
Hi,
Your expression works exactly...
Regards
Chriss