New to this, Calculating averages

chrisk · Post by **chrisk** » 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

Post by **Alex K.** » Thu Mar 22, 2012 8:25 am

Hello,

Can you please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

chrisk · Post by **chrisk** » Thu Mar 22, 2012 9:20 am

Hi Aleksy,

I wouldn't be able to upload anything due to work security policies, I was curious whether the calculation looked formatted correctly?

Post by **Alex K.** » Mon Mar 26, 2012 3:00 am

Hello,

We check your expression and it works correctly on our reports with our data.
Please clarify which version do you use.

Thank you.

chrisk · Post by **chrisk** » Thu Mar 29, 2012 8:53 am

Hi,

Version 2011.3.1200 from 1 December 2011
Flash Player 11.1.102 for Windows

Post by **HighAley** » Fri Mar 30, 2012 6:14 am

What type is the CurrentLoans.CurrentLoan_Borrower_ID field?

Please, post here in the code tag your report template for analysis or send it to support@stimulsoft.com.

Thank you.