Help create If/then formula (i think!) in Crystal 8.5

[christinetjx]

I am using Crystal 8.5 and need assistance with a formula.
I am trying to create a report that displays helpdesk calls grouped by assignment. There are many assignment groups in this company, but I only want to see 3 groups:

Calls closed on Initial (in other words, calls not escalated)
Calls assigned to a group called'Team'
Calls assigned to a group called'Depot'

I have created a 'Closed on Initial' formula that does work. (you guys helped me with this, thanks again.) Here is that formula:

If isnull ({incidentsa3.assignment}) or ({incidentsa3.assignment}) = '' then
'CLOSED ON INITIAL'
else
({incidentsa3.assignment})

Can you help me modify this formula so that I also see calls assigned to Team and calls assigned to Depot? I did do a search on 'If then' formula's (i'm assuming that is what i need) but did not come up with anything helpful. Thank you for your time. Christine

 

[MrBillSC]

In your record selection formula try:
{@YourFormulaName} = "Closed on Initial" or
{incidentsa3.assignment} in ["Team","Depot"]

MrBill

 

[lbass]

Not sure, but I think your record selection formula might be more likely to pass to the SQL if you use:

isnull ({incidentsa3.assignment}) or
{incidentsa3.assignment} = '' or
{incidentsa3.assignment} in ["Team","Depot"]

-LB