(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › derived column in reports
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic derived column in reports (Read 346 times)
debmckee
Full Member
***
Offline



Posts: 123
Joined: Oct 5th, 2011
derived column in reports
Jan 30th, 2013 at 7:28pm
Print Post Print Post  
I am trying to create a derived column in a report using the summary calculations of two other columns.  Is there an easy to do this?  It doesn't seem to like using summary columnns in derived columns.  I am trying to do a weighted average.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2483
Joined: Aug 20th, 2003
Re: derived column in reports
Reply #1 - Jan 31st, 2013 at 5:19pm
Print Post Print Post  
Hello Deb,

Any programming that references values of summary calculation elements has to come in a section after that section has run. So what you can do is add another group footer before that one, let's call it Group Footer 2 and the original one Group Footer 1. Duplicate the Summary calculation elements in the new Group Footer 2 and set them to be invisible. Then in your programmed element in Group Footer 1 reference the invisible summary calculation elements in Group Footer 2.

-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