Batch Group Record Calc

[rivet]

I would like a replace calculation to divide a found set of records into user determined batches. Here is my calc

Int ( Get ( RecordNumber ) / $div ) +1

This works great except the first group is always 1 short.

[comment]

That's because RecordNumber starts with 1, not 0. Try:

Div ( Get (RecordNumber) - 1 ; $div ) + 1

or:

Ceiling ( Get (RecordNumber) / $div )

[rivet]

as always, thanks again comment