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

    interpreting an expression...help please



      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 ... ,



      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,