Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn IB Bloggers
Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] D17.16 Data not loading properly.
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] D17.16 Data not loading properly.
 Login/Join
 
Silver Member
posted
I have a field that is D17.16. I have two transforms

DEFINE DOM_FTE/D17.16=IF FEE_TYPE EQ 'Domestic' THEN FTE ELSE 0; $
DEFINE INTL_FTE/D17.16=IF FEE_TYPE EQ 'International' THEN FTE ELSE 0; $

When run the process, instead of showing the data, I'm getting *********** values in my table. The data itself is more like D4.16, as there are results of calculations that have long repeating numbers. (Like 1/3). What am I doing wrong?

This message has been edited. Last edited by: Chuck Wolff,


WebFocus 8.104
Windows 7 Entreprise, SP1
 
Posts: 31 | Location: Abbotsford BC | Registered: March 15, 2010Reply With QuoteReport This Post
Master
posted Hide Post
D format has a max of 15 significant digits. Try P format, it goes to 32 or 33 significant digits.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.
 
Posts: 778 | Location: Oklahoma City | Registered: October 27, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
I think D format should work, but D17.16 will not work as the 17 is the total number of characters

Dt[.s]  where:

t
Is the number of characters to display up to a maximum of 33, including the numeric digits, an optional decimal point, and a leading minus sign if the field contains a negative value. The number of significant digits supported varies with the operating environment.

s
Is the number of digits that follow the decimal point. 31 and must be less than t.


So you should try D33.16

Martin.


WebFocus 7.6.9/7.7.06M, iWay DataMigrator, ISM, Windows, DB2 Windows V10.5, MS SQL Server, Hyperstage
 
Posts: 109 | Registered: March 29, 2013Reply With QuoteReport This Post
Silver Member
posted Hide Post
Hey guys, thanks for the help. I made the change D33.16 and no longer have a problem.


WebFocus 8.104
Windows 7 Entreprise, SP1
 
Posts: 31 | Location: Abbotsford BC | Registered: March 15, 2010Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  iWay Software Product Forum on Focal Point    [SOLVED] D17.16 Data not loading properly.

Copyright © 1996-2017 Information Builders, leaders in enterprise business intelligence.