Count({$<[Pump ID]=P({1<[%Link Pump Group]={"*$(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{<[DYN Group Param Id]=p([DYN Group Param Id])>}[%Link Pump Group]))*"}>}[Pump ID])>}[Pump ID])
As I want to get the count of PUMP ID
based on the values coming from
(=count(DISTINCT [%Link Pump Group])-count(DISTINCT{<[DYN Group Param Id]=p([DYN Group Param Id])>}[%Link Pump Group])
this expression returns 76 but when I placed this espression then it is not wotking . actually this 76 is my count but I want 76 values coming in my SQL script.
Is this right or please correct me.