6 Replies Latest reply: Dec 29, 2010 4:20 AM by msadrikhcb RSS

    IF statement and set analysis problem

      Hi All,

      I have a pivot table in which i have used the following if statement for an expression;

      If(Left(GENERAL_LEDGER.GL_CODE,1)<>1 and Left(GENERAL_LEDGER.GL_CODE,2)<>21 and
      Left(GENERAL_LEDGER.GL_CODE,2)<>28 and Left(GENERAL_LEDGER.GL_CODE,3)<>3 and
      Left(GENERAL_LEDGER.GL_CODE,4)<>4 and Left(GENERAL_LEDGER.GL_CODE,5)<>5 and
      Left(GENERAL_LEDGER.GL_CODE,6)<>6 and Left(GENERAL_LEDGER.GL_CODE,7)<>7 and
      Left(GENERAL_LEDGER.GL_CODE,8)<>8 and Left(GENERAL_LEDGER.GL_CODE,9)<>9,
      Sum({<TRANSACTION_HISTORY.VALUE_DATE= {"<$(=CALENDAR.VAR_DATE_ONE)"}>} TRANSACTION_HISTORY.CV_AMOUNT))

      This expression is prvoing to be too big and slows down the .qvw operation.

      I wanted to know if there is some way through which i could shorten it or maybe im doing it wrong and there is another way of getting the same result.

      Thanks.