Finding Last Record

[yogesh_gothe]

Hii all,
New To Crystal Report...How can I exclude the last record from the Summary or Average of a Field

the Shift Day and Shift ID selection grouping is done but I dont want in the summary -- Sum or Average the last record to be added.



What formula function to be used and what is work of OnLastRecord.
Please help.
Yogi

[jggtz]

Insert 2 groups
One for date one for shiftid
Supress GroupHeaders and Details Sections
Set the data onto ShiftId Group Footer
and try

[yogesh_gothe]

Thnks for your immediate response. But I have the reports done which is grouped for the Shift and Day. All the other data is either averaged or sum in that report. But one data called as Production data out of this group must have sum of all the production in that shift EXCEPT the last record. Is it possible .. and how can I use the ONLastRecord for this.