1 Reply Latest reply: Sep 5, 2018 10:48 AM by Chanty 4u RSS

    Nested SET Analysis with Larger or Less Than

    Ali Ahmad

      Hi,

       

      I am trying to write a Nested SET Analysis Expression.

       

      I want to Count the ClientNo's where the sum of account numbers connected to that ClientNr is larger than 0.

       

      I have tried with:

       

       

       

      Count(Distinct {<

       

      ClientNo =

       

      {"

       

      Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)

       

      >  0

       

      "}

       

      >}ClientNo)

       

      The issue seems like it is that there are two " " inside of the nested part.

       

      Any suggestions?

       

      Best,

       

      Ali A