Focal Point
Amper Variable multiplication [SOLVED]

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/34510712

February 26, 2009, 12:16 PM
Mark1
Amper Variable multiplication [SOLVED]
Hello,
I am reading a saved file like this:

-READ MYTABLE5 &PAY_END_DT.A17 &PAY_BEGIN_DT.A17 &MAX_COUNT.I10

The last variable (&MAX_COUNT) needs to be used in multiplication like this:

WFTES/D15.4=(WORKEDHRS / ((80)*(&MAX_COUNT));

However, I keep getting this error:

0 ERROR AT OR NEAR LINE 125 IN PROCEDURE ADHOCRQ FOCEXEC *
(FOC262) UNBALANCED PARENTHESES

Can anybody tell me how I can solve this problem. Thank you!

This message has been edited. Last edited by: Mark1,


Windows version 768
February 26, 2009, 12:18 PM
Francis Mariani
The answer is in here:

quote:
(FOC262) UNBALANCED PARENTHESES



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 26, 2009, 12:18 PM
Tom Flynn
Just keep adding parenthesis!!!

WFTES/D15.4=(WORKEDHRS / 80) * &MAX_COUNT.EVAL;

Algebra 101...


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 26, 2009, 12:20 PM
Tony A
The answer is in the error! Count your left hand parentheses and then count the right hand ones - difference?
quote:
WFTES/D15.4=(WORKEDHRS / ((80)*(&MAX_COUNT));
T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
February 26, 2009, 12:20 PM
Francis Mariani
or keep removing them!!!!

WFTES/D15.4 = WORKEDHRS / 80 * &MAX_COUNT ;



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 26, 2009, 12:21 PM
Tony A
Someone else having a bad day! Wink
February 26, 2009, 12:41 PM
Francis Mariani
I just had to have one more exclamation mark than Tom Smiler


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
February 26, 2009, 12:45 PM
Tom Flynn
touché!!!


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
February 26, 2009, 12:48 PM
Mark1
Whoops! Sorry for wasting everyone's time. One of those days?... yeah.


Windows version 768
February 26, 2009, 01:25 PM
FrankDutch
who said wasting.....you need a smile every day

please change your subject to [solved]




Frank
prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7