interpreting an expression...help please

[#1]

Hello,

I have to count a field and I have a small problem.

How this expression can be interpreted into expression tab inside a pivot table:

if(policy.POLICY_STATE>=0 and policy.POLICY_STATE<=30 and ... ,

  count(POLICY_ID))

I would like to count only POLICY_ID's that are in 'tab1' table.

Where should I put this condition?

It should be something like count(POLICY_ID from table 'tab1')

Thank you,

Silviu.

[#2]

or count ONLY the POLICY_ID's that are in table 'tab1'...how this can be inserted into a expression ?

[Anonymous]

Hi

     You just try to count the Policy_id values from the table which are all in the tab1 edit script

Regards

Ashok

[#4]

I am counting only the POLICY_ID's that meet the conditions and only those that are in my table 'tab1'.

How can this be possible, because I'm sure that is a simple function...

[marcos]

Hi,

try the expresion in this way:

count( if(policy.POLICY_STATE>=0 and policy.POLICY_STATE<=30 and ... ,  POLICY_ID))

the problem is that the condition must be inside the count function