How to write set expression?

[#1]

  how to write set expression for below code

count ({<BusinessProcessStatus={'New'} DepartmentGUID)

[newqlikie]

Hi,

try this:

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

Regards

[nizamsha]

=count({$<BusinessprocessStatus={"New"}>}departmentguid)

[#4]

Hi thanks

its working fine

but i want distinct department guid.

thanks

[newqlikie]

=count({$<BusinessprocessStatus={"New"}>}distinct(departmentguid))

[#6]

count(DISTINCT{$<BusinessprocessStatus={"New"}>}departmentguid)

[nizamsha]

count(DISTINCT{$<BusinessprocessStatus={"New"}>}departmentguid

[#8]

try this

=count(Distinct  {$<BusinessprocessStatus={"New"}>}departmentguid)