Creating count from queried fields

[Former Member]

Post Author: John

CA Forum: Formula

Hello all. Newbie here to the forum and CR.

Running CR 9

I have a report that extracts certain data from the database. A field that displays "test code", is not part of the original search criteria. I have been asked to total "test code" but, I don't know how to count the records from the extracted data.

For example, I'm pulling in everyone with a last name that begins with a "J" and who came in the store from 01/01/07 - 01/31/07. I then list the data and also print their address, city, state, zip, and "test code". The "test code" is one of 3 possible codes. I want to have 1 running total for each of these 3.

My knowledge allows me to create a running total on the field but, the total is from ALL of the records that match.

So, if we had 45 people with "J" and 01/01/07 - 01/31/07, the running total will be 67 because it is finding all data sets that match it's code. It isn't pulling from the original search criteria of "J" and 01/01/07 - 01/31/07.

Any help is appreciated.

John

[Former Member]

Post Author: Charliy

CA Forum: Formula

If you're using Running Total then you're more than halfway there.

To only count the ones with the test code, edit your running total and click the box that say Evaluate on Formula, the box next the on you click will turn red, click on the red box and you'll be in a formula editor. create a formula like: {table.codefield} = 'testcodevalue" now clidk the Save and close button and you're done.

You might also want to consider whether you want Count or Distinct Count. If there could be more than one record per person, and your counting on a customer id, then Count is the number of records, while Distinct Count is the number of customers.