Crystal Reports 2013: Creating a Formula with filters to run a calculation

Hello All,

I hope this is an easy one for you. I am stomped. I use Crystal Reports 2013 for Reporting Service Desk Tickets. I would like to run a formula only when an item is a certain category. I can create a record selector and limit the category, but then I would need to create a bunch of sub-reports because other formulas in my report should not display filtered criteria. I am missing some kind of "Select from" statement. This is what I would like to obtain from the formula:

If {Category} = "Major" and {Status} = "Closed" then avg({Deployment Hours}) else

If {Category} <>"Major" and {Status} <> "Closed" then 0

Issue: If my criteria is met, the formula will average all [Deployment Hours] and not limit the average to only items with a [Category] = "Major" and [Status] = "Closed".

I can obtain the info using a cross-tab, but I wanted to save space on the report. I wanted to obtain the result using a formula. Does anyone know how to see the formula used by a cross-tab? If I can see what formula the cross-tab is using, I can solve my answer.

Background: Each ticket has a category. I can obtain results for how many Major are Closed. I can obtain the Average of all Deployments, but I would like to only run the avg([Deployment Hours]) for tickets that are Closed and are Majors.

{Category} = text

{Status} = text

{Deployment Hours} = number

**Update**

After doing some research on Case Statements for Crystal Reports, I think I am on the right track. Can someone verify if the below statement is correct? My statement is looking at all Closed Status. When there is a Closed item that is classified as Major, the calculation "avg{Deployment Hours}" will be ran only for the Closed/Major items.

select {Closed Status}

case {Major Category}:

avg{Deployment Hours}

Default:

0;