Set Analysis

[#1]

Hi All,

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

Thanks in advance!

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)))

[#2]

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"")

[Sokkorn · Accepted solution]

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

[kumarnatarajan]

Hi,

try this.

Ex:

=If(ReasonAna='Grand Total',

Count(

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