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

    Nested SET Analysis with Larger or Less Than

    Ali Ahmad



      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






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


      Any suggestions?




      Ali A