5 Replies Latest reply: Sep 29, 2011 2:59 AM by Paul Steyn RSS

    How to use positive and negative logic simulatniously in Set Analysis

      Hi there

       

      I have 2 statements I would like to use in one Set Analysis statement. Individually they work a charm, but together I have no luck:

       

      Statement 1:sum({$-1<ProductBrand = {'*Certificate*', '*Bank*'}>} NrOfExchTxns) // In this statement I want all Txns where the ProductBrand is not Certificate or Bank

       

      Statement 2:

      sum({$<CallMade={1}>} NrOfExchTxns)  // In This statement I want all Txns where the CallMade value = 1

       

       

       

       

      Pretty simple one would think, but I have tried various scripts with the following being my latest stab at it, with no positive result:

       

      sum( {$<CallMade = {"=sum({$-1<ProductBrand = {'*Certificate*', '*Spacebank*'}>}  NrOfExchTxns) = {1}"}>} NrOfExchTxns )

       

      Any suggestions?

       

      Many thanks

      Paul