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



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Calculation problem in report
Feb 6th, 2018 at 9:45pm
Print Post Print Post  
I'm trying to print a calculated number in a group footer 1, using sums generated in group footer2.  I'm trying to calculate in an unbound element called "SumPcsPerHour", which is in group footer 1, using summary data "SumTtlPcs" and "SumHours".

All three elements are formatted as NUMBERS.

The calculation is simply:

SumPcsPerHour=SumTtlPcs/SumHours

However, I keep getting an error message:

"Error while parsing module "SumPcsPerHour (0)":
"Type Mismatch error (operation not defined for the types of operands"

It then shows me the position of the error, and highlights the "/" symbol.

What am I doing wrong?
  
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: Calculation problem in report
Reply #1 - Feb 7th, 2018 at 2:56pm
Print Post Print Post  
Are both SumTtlPcs and SumHours shown as Bound To Type Number?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
NHUser
Full Member
***
Offline



Posts: 320
Location: Amherst, NH
Joined: Aug 2nd, 2010
Re: Calculation problem in report
Reply #2 - Feb 8th, 2018 at 2:28pm
Print Post Print Post  
Yes, all elements are bound to NUMBER types.
  
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: Calculation problem in report
Reply #3 - Feb 8th, 2018 at 9:32pm
Print Post Print Post  
Hi Paul,

I just tried it here with a simple report built in Customers.db and it compile just fine so it is likely something particular to your design.

If you wanna send in your design, I can take a look at it here or I can hop on your system one day next week and take a peek at it. Shoot me over an e-mail with how you want to proceed and we'll go from there.

-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