5 Replies Latest reply: Jun 7, 2017 3:01 PM by Sunny Talwar RSS

    Sum Total not working in Straight Table

    Justin Dallas

      Hello Everyone,

       

      I've got a General Ledger chart, and I want to hide all accounts where the the "Debits - Credits" sum is zero (not activity on the account). To accomplish that, I've got this statement here

       

      If(SUM( TOTAL YeartoDateTransactionDebitAmount)  > 0,
        DSCRIPTN,
          Null()
      )
      
      

       

       

      This is incomplete however, because it doesn't work over the specified dimension.  So then I added this, the "<DSCRIPTN>".

       

      If(SUM( TOTAL <DSCRIPTN> YeartoDateTransactionDebitAmount)  > 0,
        DSCRIPTN,
          Null()
      )
      
      

       

      and now it doesn't work.  I'm not sure why.  Does anyone know why it does.  What I'm trying to say here is "Does the Sum of YearToDateTransactionDebitAmounts come to greater than zero for this DSCRIPTN, if so, show it"

       

      Any help is greatly appreciated.

       

      EDIT: However, this works

       

      if(Aggr(sum(YeartoDateTransactionDebitAmount),DSCRIPTN) > 0,DSCRIPTN)