(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Average of a calculation in a report
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Average of a calculation in a report (Read 14207 times)
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Average of a calculation in a report
Apr 30th, 2020 at 8:10pm
Print Post Print Post  
I'm trying to calculate the average of a report element that is a result of a calculation. 

For example, the calculation is Heats/hour=(heats/hours)*8.5

This easily is calculated for each line in the report. I want to calculate the average Heats/hour for the entire report in the group footer.  Is this possible (easy)?

Any help is appreciated.

NHUser
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: Average of a calculation in a report
Reply #1 - May 1st, 2020 at 2:51pm
Print Post Print Post  
Hi Paul,

Select your calculation element in your report. On the Format tab of the Property Editor be sure to set the format unbound as to Number if you have not already done so. Then you can add a Summary Calculation - Average element to your group footer bound to your calculation element.

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge