This content has been marked as final. Show 5 replies
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)