0 Replies Latest reply: Nov 30, 2014 12:02 PM by Agnivesh Kumar RSS

    Please correct my expression

    Agnivesh Kumar

       

      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.