Subtotal - IF Function - SUM - AR Aging

[Anonymous]

Hi I have problem on expression syntax. New on using QBAR-QlikView.

if((Age >= 0) and (Age<= 30),OpenBalance*1,0)

Can somebody help me with the code expression.

I think I miss SUM but i dont know the code.

Thanks in advance

[Anonymous]

I name columns / expression as

Age:

_ReportFilterAsOfDate - Date

OpenBalance:

sum(If (Transactions.Pending = 0 or IsNull(Transactions.Pending),

if ((Match ([Transactions.Txn Type], 'Receive Payment', 'Credit Memo', 'CreditCardCredit') or (Match ([Transactions.Txn Type], 'Journal') and Match([Transactions.Debit Or Credit], 'Credit'))), -[Transactions.Balance Remaining], [Transactions.Balance Remaining])))