4 Replies Latest reply: Feb 17, 2012 3:45 PM by Marcos Gomez RSS

    interpreting an expression...help please

    silviu andries

      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.