# of records in dataset

[R7Dave]

Hello

I'm trying to do percentages using the record count.

I need to use the count from my DataSet to do calculations.

So if I have 10 records, 2 are type A and 8 are type B, my report would look like

Type A - 20%
Type B - 80%

My SQL statement groups a lot and so does the report - how can I get the record count? Is there something like RecordCount(DataSet)?

I have tried using Count() but that gives me the count of the filed in the details section.

Thanks in advance
Dave

 

[RiverGuy]

You can specify the scope in a lot of the built in functions. So, instead of COUNT(SomeField), you can do COUNT(SomeField, YourDataSetName) to get your total count.

 

[R7Dave]

Thank you RiverGuy - that was what I needed.

Thanks
Dave