Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try this
Count({<ClientNo ={"=
Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)>=0"}>}distinct ClientNo)
or
Count({<ClientNo ={"=
Sum({<AccountNumber = P({<FactType= {'Accounting'}, AccountNumber= {">=2800<=29899"}>})>}Amount)>0"}>}distinct ClientNo)