First Record in a group 1

[Smithsc]

Is there any functions similar to "OnFirstRecord" that can calculate the first record of a group.

 

[lbass]

You can use a clause like this in your formula:

(
onfirstrecord or
{table.groupfield} <> previous({table.groupfield})
)

You need to build in the "onfirstrecord" since for the first record there is no previous field, and the formula would otherwise return a null.

-LB

 

[Smithsc]

Thanks Ibass. That worked perfectly