Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Reversing a Numeric Sign

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Reversing a Numeric Sign
 Login/Join
 
Member
posted
Hello all,

Can anyone tell why:

COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / 100);
AS 'COMM-AMT'

works fine.

But
COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / -100);
AS 'COMM-AMT'

Returns the error msg:
0(FOC260) AN OPERATION IS MISSING AN ARGUMENT

Thanks to all!

Webfocus 5.3.2 soon 7.1.4 IBM mainframe


WebFocus 532 soon to be 714 IBM OS/390
 
Posts: 11 | Registered: January 11, 2007Report This Post
Silver Member
posted Hide Post
Try:

COMPUTE Total_AMT/P16.2C = (Sales * COMMISION / (-100));
AS 'COMM-AMT'

Good Luck,
P
 
Posts: 42 | Location: UK | Registered: October 23, 2005Report This Post
Virtuoso
posted Hide Post
COMPUTE Total_AMT/P16.2C = -1*(Sales * COMMISION / 100);
AS 'COMM-AMT'




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Platinum Member
posted Hide Post
or this..

COMPUTE Total_AMT/P16.2C = (-1) * (Sales * COMMISION / 100);
AS 'COMM-AMT'

Goooooooooood day !!
Sandeep Mamidenna


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
 
Posts: 218 | Location: Jackson, MS | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
You can not have two operators (/-) together, and you can separate them by adding ()around the negative number.
 
Posts: 118 | Location: Omaha, NE | Registered: June 12, 2003Report This Post
Platinum Member
posted Hide Post
Agreed. No two operators together...
Try this:
COMPUTE Total_AMT/P16.2C = ((Sales * COMMISION / 100) * -1); AS 'COMM-AMT'
Also be careful if mixing and matching case - especially if in the Unix world.

Ira....


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
Member
posted Hide Post
Hello All,

I went with this solution and it works file:

COMPUTE Total_comm/P16.2C = -1*(Sales * COMMISSION_PCT / 100); AS 'COMMISSION-AMT'

Thanks!


WebFocus 532 soon to be 714 IBM OS/390
 
Posts: 11 | Registered: January 11, 2007Report This Post
Virtuoso
posted Hide Post
nice to know
I just wonder why you have this computed field as a Packed format instead of Decimal.

What is the main difference to use packed or decimal?

Can someone give me a reason?




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

 
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006Report This Post
Expert
posted Hide Post
It has to do with the way rounding happens and the depth of decimal carrying.
packed is best for monetary figures.




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Report This Post
Expert
posted Hide Post
Frank,

Basically (and I know there is more to this but I'm keeping it basic),

D format retains all decimal positions as it is passed through the various processes so even when you have D20.2, if you put 3.1415927 into it it will still retain the full value in any calculations etc. but in display it will only show 3.14. Add five of the same together and you should get 15.71 and not 15.70.

P or packed decimal, as Susannah states, is best for monetary values if you are working to a spcific number of decimals. Place 3.1415927 into a P20.2 and it will use 3.14 and lose any precision you might want.

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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Platinum Member
posted Hide Post
Tony A. Gret reply; I could not have put it better myself.


aix-533,websphere 5.1.1,apache-2.0,
wf 538(d), 537 (p),
==============
7.6.11 (t) aix 5312
websphere 6.1.19
apache 2.0
 
Posts: 195 | Registered: October 27, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Reversing a Numeric Sign

Copyright © 1996-2020 Information Builders