sort checksum

[rivet]

I have a list of line items with a sort field, that should number the record sequentially starting at 1.

On record commit, I want to check that the sort numbers are sequential and if not run a script to number them so.

 

I figure there might be a formula that could check the sum of the sort column against the number of records.

 

i.e.:  if there were 8 records, the sort sum should equal 36.

 

Sort# Sum 

01  01

02  03

03  06

04  10

05  15

06  21

07  28

08  36

09  45

10  55

[eos]

The formula is ( 1 + x ) * x / 2

[comment]

I figure there might be a formula that could check the sum of the sort column against the number of records.

 

The sum of the sort column returning the expected result does NOT necessarily mean that the records are numbered sequentially starting at 1. Why don't you use a summary field or record number to number them dynamically?

[rivet]

Thank you both suggestions are helping.