How to write set expression?

[#1]

Hi,

How to write set expression for below condition

= count({$<BusinessProcessStatus={"New" and "Accepted" } >}DISTINCT DepartmentGUID)

thanks

[omyahamburg]

Changing {"New" and "Accepted"} to {'New','Accepted'} should make it work.

[#3]

count({$<BusinessProcessStatus={'New' , 'Accepted' } >}DISTINCT DepartmentGUID)

[Anonymous]

Hi,

Try this,

= count({$<BusinessProcessStatus={'New','Accepted'} >}DISTINCT DepartmentGUID)

[Anonymous]

try this

= count({$<BusinessProcessStatus={"New" } *BusinessProcessStatus={" Accepted" } >}DISTINCT DepartmentGUID)

[narender123]

Hi,

Try this.

if(BusinessProcessStatus='New' and BusinessProcessStatus='accepted',

count(DISTINCT DepartmentGUID))

[jagan]

Hi,

Try this hope it helps you

= Sum(Aggr(If(count({<BusinessProcessStatus={"New", "Accepted" } >}DISTINCT BusinessProcessStatus) = 2, 1, 0)

DepartmentGUID))

Regards,

Jagan.