help on set analysi exp

[Anonymous]

Hi All, I need help on this below set analysis. All I need is for few of the column I need to show "PASS" or "Fail" based on Metricvlaue.If any of the value contains I need to show "Fail" only.else remaing values. somehow it is not working.

if(count(

{<MetricName={'M1','M2','M3','M4'},

MetricIndexvlaue={'FAIL'},MetricIndexPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)>0,'Fail','PASS'),

sum({<MetricPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)

/count({$<MetricPlant-={'M6'}>}distinct MetricPlant)

[dan_sullivan]

looks like you need a final parenthesis on the end:

if(count({<MetricName={'M1','M2','M3','M4'},MetricIndexvlaue={'FAIL'},MetricIndexPeriod ={'$(=$(v_previous_month))'}>}Metricvlaue)    >0

,'Fail',

sum({<MetricPeriod = {'$(=$(v_previous_month))'}>}Metricvlaue)

/count({$<MetricPlant-={'M6'}>}distinct MetricPlant))