New to this, Calculating averages
Posted: Thu Mar 22, 2012 5:23 am
Hi Everyone,
I have created my new report and added into the report a count {Count(DataBand,CurrentLoans.CurrentLoan_Borrower_ID)} which works and gives me the results I want. I would like to add into the group footer the averaged from the counts results, I have tried the following {Avg(DataBand,CurrentLoans.CurrentLoan_Borrower_ID)} but always get 0.
Thanks for any help in advance
I have created my new report and added into the report a count {Count(DataBand,CurrentLoans.CurrentLoan_Borrower_ID)} which works and gives me the results I want. I would like to add into the group footer the averaged from the counts results, I have tried the following {Avg(DataBand,CurrentLoans.CurrentLoan_Borrower_ID)} but always get 0.
Thanks for any help in advance