Help with Counts

[theladebug]

I'm fairly new at creating these crystal reports, and need a little help. I am creating a report grouped by employee, showing all files closed by that employee along with revenue, then summaries of number of files, total revenue and average revenue per file. However, I need to seperate out certain files from the list to be totalled seperately & averaged separately. This cannot be done by file type, but rather the file number (Some file numbers start with "TO" others "TX") I've experimented with different count formulas, and cant create one with the correct results.

Any suggestions?

 

[lbass]

You could insert an inner group on the following formula:

if {table.fileno} startswith "TO" then "TO Files" else
if {table.fileno} startswith "TX" then "TX Files" else
""

Then you could just insert summaries for this group.

-LB

 

[synapsevampire]

As with any development product, please try to remember to post your software version when requesting technical information.

It sounds like you want a Running Total, and in the evaluate->use a formula place something like:

{table.field} startswith "TO"
or
{table.field} startswith "TX"

Then for those that you do not want to include those values, use another running total with a different formula of:

not(
{table.field} startswith "TO"
or
{table.field} startswith "TX"
)

Another means is to create a formula for the details and use conventional summaries (right click and select insert summary) on it, it might look like:

if {table.field} startswith "TO"
or
{table.field} startswith "TX"
then
1
else
0

The other formula would then be:

if not({table.field} startswith "TO"
or
{table.field} startswith "TX"
)
then
1
else
0

-k