Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need to enhance existing formula

Status
Not open for further replies.

kwr04

Programmer
Jan 15, 2010
11
0
0
US
Shared NumberVar extreme_urgent_count;
If {ESI_esi_audit_hpd_hpd_helpdesk_JOIN.Priority} = "Urgent" Then extreme_urgent_count := extreme_urgent_count +1 Else
extreme_urgent_count := extreme_urgent_count;
extreme_urgent_count


If I have one urgent ticket that gets assigned first to one group then to another group and I only want to count it once. How can I add additional code to this existing code above to accomplish that?

Example of two data records working with:
Ticket# request-id assigngroup priority date submitter
839186 3175040 xxxxxxxx urgent 01/18/6:14 Joe
839186 3175044 oooooooo urgent 01/18/6:15 jill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top