5 Replies Latest reply: Aug 27, 2014 7:14 AM by Gary McDonald RSS

    Rowno() per unique field?

    Gary McDonald

      Good afternoon,

       

      I am hoping someone may be able to help with the following problem I have encountered and I am grateful for any help you may be able to provide.

       

      The problem:

           I need to count the number of occurrences a policy number appears in a claims report, however I need each occurrence of the policy number to be numbered sequentially from 1 upwards.

       

      The date looks like this:

           ClaimsReport:

           LOAD

           Policy_Num,

           Claim_Num,

           ClaimCost

           From [F:Claims Report.xlsx];

       

      For example I need a line of script that can create the field 'Policy_Claim_Count'

       

      Policy_NumClaim_NumPolicy_Claim_Count

      POL_001

      Claim_006

      1

      POL_002Claim_0091
      POL_003Claim_0011
      POL_003Claim_0022
      POL_004Claim_0031
      POL_005Claim_0051
      POL_006Claim_0041
      POL_006Claim_0072
      POL_006Claim_0083

       

      Thanks for any help

      Gary