3 Replies Latest reply: Jul 11, 2013 3:26 AM by Kumar Natarajan

# Set Analysis

Hi All,

May I get some help to write the below mentioned Set Analysis code in better way?

If(ReasonAna='Grand Total',(Count({\$<[Service Delay]={1}>}INCIDENT_NO) or Count({\$<[Spare Delay]={1}>}INCIDENT_NO) or Count({\$<[Engineer Skill Set]={1}>}INCIDENT_NO) or Count({\$<[Helpdesk Issue]={1}>}INCIDENT_NO)))

• ###### Re: Set Analysis

Try...

if(GetFieldSelections(ReasonAna)= 'Grand Total',
Count({\$<[Service Delay]={1}>}INCIDENT_NO)

or Count({\$<[Spare Delay]={1}>}INCIDENT_NO)
or Count({\$<[Engineer Skill Set]={1}>}INCIDENT_NO)
or Count({\$<[Helpdesk Issue]={1}>}INCIDENT_NO)
,

""Default"")

• ###### Re: Set Analysis

Hi,

Try this:

If(ReasonAna='Grand Total',

Count({\$<[Service Delay]={1}>+<[Spare Delay]={1}>+<[Engineer Skill Set]={1}>+<[Helpdesk Issue]={1}>} [INCIDENT_NO])

)

Regards,

Sokkorn

• ###### Re: Set Analysis

Hi,

try this.

Ex:

=If(ReasonAna='Grand Total',

Count(

{\$<[Service Delay]={1}> + <[Spare Delay]={1}> + <[Engineer Skill Set]={1}> + <[Helpdesk Issue]={1}>} INCIDENT_NO))