Record count formula

[Former Member]

Post Author: davinap

CA Forum: Formula

Hello,

I am trying to do a record count formula that sits on the details line (so it just goes 1, 2, 3, 4, 5, 6 etc down the rows). Please help!

Thanks,

Davina

[Former Member]

Post Author: bryanflora

CA Forum: Formula

Did you try what I said?If the total sales is a simple column, that's already what you want!If the total sales is a total column(by summary).Then the running total have to change into distinct count.That's just like that.

[Former Member]

Post Author: davinap

CA Forum: Formula

Thank you, but I want something a little different.

I want to have a rank for each record within the group and reset the rank on each group i.e

Total Bear sales by Store (where bear is the record and store is the group):

Bear Colour Total Sales Rank

Melbourne Store

Blue Bears 50 1

Purple Bears 45 2

Green Bears 36 3

Yellow Bears 21 4

Total Records 4

Sydney StoreGreen Bears 53 1

Purple Bears 45 2

Blue Bears 34 3

Yellow Bears 22 4

Total Records 4

Perth Store

Orange Bears 50 1

Purple Bears 45 2

Green Bears 36 3

Yellow Bears 21 4

Total Records 4

Darwin Store

Yellow Bears 50 1

Green Bears 45 2

Purple Bears 36 3

Blue Bears 21 4

Total Records 4

[Former Member]

Post Author: bryanflora

CA Forum: Formula

If you want to get the record number and reset for each group.You can use running total instead.In the running total, you set the summary as count, then choose a field, the primary key field is the best.And set the running total to reset by your desired group.Then put the running total in Details.

[Former Member]

Post Author: davinap

CA Forum: Formula

I wish it was that simple!!

I need to have the record count within each group, so it needs to be set at the start of the new group. Any help with formulas would be great as I can't quite get the 3 formulas to work!

Thanks.

[Former Member]

Post Author: SRK

CA Forum: Formula

hey , can you tell me exactly how to implement this .I was looking for this and if i use the record number its not printing in serial order its printing 2,3,5,6,8,9,.......please helpSRK

[Former Member]

Post Author: Jagan

CA Forum: Formula

If all you need is the number of records per group, from the menus choose Insert.Summary

Chose the field to summarize: doesn't really matter which one

Calculate this summary: Count

Summary location: your group

Crystal'll put the summary in the group footer but you can move it to the group header if you want it there instead.

[Former Member]

Post Author: davinap

CA Forum: Formula

Thank you! I knew it would be something simple! : )

This has worked for part of my report. But in another subreport I need to use grouping and set the record number to 0 at the start of each group, I think I need to set up 3 formulas, one in the group header to set it to 0, one in the details for the starting count plus 1 for each increment, and one to display the total count in the group footer. I just need to know what I need to type into each fomula?

Thanks,

Davina

[Former Member]

Post Author: Jagan

CA Forum: Formula

See the help on RecordNumber...