The data returned includes many accounts, and values associated with the accounts (debit, credit, closing balance etc).

 

All i need to do is get the sum'd closing balance for a particular account, which in this case is "10090 - Investments".

 

The problem is that this account is part of a few funds, and i want to get the sum of the closing balance for this account across multiple funds.

 

for example...

 

Fund 1   10680 - Cash                                    15,000.00

Fund 2   10170 - Payback                               46,000.00

 

I would just want to see the bold values sum'd, which would be 45,000.00

 

apologies if this makes no sense... please ask for additional information.

 

I tried the following code but this didnt bring out the correct value:

 

iif({Summary_Trial_Balance.Account} = "10090 - Investments", sum({Summary_Trial_Balance.Ending Balance}), 0)

 

Thanks in advanced.