Alternate State

[Ramki]

Hi All,

I have created alternate states Group 1 ,Group 2  and assigned to below expression but the result  return is zero count

Appreciate can any one help me out for expression 

Measure 1 :  count({[group1]< SelectedMonth={'$(=GetFieldSelections(MonthToSelect))'}>}EquipmentId)

Measure 2: count({[group2]< SelectedMonth={'$(=GetFieldSelections(MonthToSelect))'}>}EquipmentId)

Regards,

Ramki

[kaushiknsolanki]

Make sure that the name of the Group is written properly, it is a case sensetive. 

[Ramki]

Hi Kaushik,

Thanks for reply. By mistake mentioned query. In my expression I have written correctly but expression is not working.

Regards,

Ramki

[kaushiknsolanki]

Is your expression working without defining the Group?

[Ramki]

Hi Kaushik,

group names are Group 1 , Group 2 and expressions are below.

Measure 1 :  count({[Group 1]< SelectedMonth={'$(=GetFieldSelections(MonthToSelect))'}>}EquipmentId)

Measure 2: count({[Group 2]< SelectedMonth={'$(=GetFieldSelections(MonthToSelect))'}>}EquipmentId)

Regards,

Ramki