Grand total is not showing for all entites
Posted: Thu Dec 17, 2015 3:32 pm
Hi,
Could you take a look at my file and see what might be missing from my formula? My formula used is:
{Totals.Sum(DataBand5,Intercompany_Loans.Intercompany_Loans_USD)+Totals.Sum(DataBand3,ICA.ICA_Statement_Balance_USD)+Totals.Sum(DataBand4,Term_Deposits.Term_Deposits_USD)+Totals.Sum(DataBand2,Bank_Accounts.Statement_Balance_USD_Equivalent)}. Please let me know if you need further clarification, but the report is supposed to take the total of the Term Deposits/Bank Balances for each entity and the total of the Loans and Statement Balances for each entity where applicable. For some reason it totals both for some entities and just one for others. Thanks!
Best,
Andy Moncion
Could you take a look at my file and see what might be missing from my formula? My formula used is:
{Totals.Sum(DataBand5,Intercompany_Loans.Intercompany_Loans_USD)+Totals.Sum(DataBand3,ICA.ICA_Statement_Balance_USD)+Totals.Sum(DataBand4,Term_Deposits.Term_Deposits_USD)+Totals.Sum(DataBand2,Bank_Accounts.Statement_Balance_USD_Equivalent)}. Please let me know if you need further clarification, but the report is supposed to take the total of the Term Deposits/Bank Balances for each entity and the total of the Loans and Statement Balances for each entity where applicable. For some reason it totals both for some entities and just one for others. Thanks!
Best,
Andy Moncion