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

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Is this a valid statement
Go
New
Search
Notify
Tools
Reply
  
[CLOSED] Is this a valid statement
 Login/Join
 
Platinum Member
posted
NEW_VALUE/P13.6 MISSING ON = IF (SORC_FEE_ID EQ '04G') AND (FEE_RETL_AM LT 0.1) THEN 0 OR
IF (SORC_FEE_ID EQ '10X') AND (FEE_RETL_AM LT 0.1) THEN 0 OR
IF (SORC_FEE_ID EQ '10Y') AND (FEE_RETL_AM LT 0.1) THEN 0 OR
IF (SORC_FEE_ID EQ '22E') AND (FEE_RETL_AM LT 0.1) THEN 0 OR
IF (SORC_FEE_ID EQ '04I') AND (FEE_RETL_AM LE .1) THEN 0 ELSE FEE_RETL_AM

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




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
This is what i needed...thanks

NEW_VALUE/P13.6 MISSING ON = IF (SORC_FEE_ID EQ '04G') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '10X') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '10Y') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '22E') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '04I') AND (FEE_RETL_AM LE .1) THEN 0 ELSE FEE_RETL_AM;




Prod: WebFOCUS 7.6.10 MRE
Oracle/Sybase
Test: DevStudio 7.6.6
WF Server 7.6.6
Report Caster 7.6.6
Web Server - Tomcat
MS Windows XP SP2
Output: HTML, Excel 2000 , PDF, CSV, DOC

 
Posts: 133 | Registered: December 29, 2006Reply With QuoteReport This Post
Gold member
posted Hide Post
I could be wrong but I am thinking that your second post may not be doing as you think. I think it is seeing something like this:
 IF (SORC_FEE_ID EQ '04G') AND
((FEE_RETL_AM LT 0.1) OR (SORC_FEE_ID EQ '10X'))



I am not sure in your case but wouldn't this work how you want?

NEW_VALUE/P13.6 MISSING ON= IF (SORC_FEE_ID EQ '04I' AND FEE_RETL_AM LT .1) OR (SORC_FEE_ID IN ('04G', '10X', '10Y', '22E') AND FEE_RETL_AM LE .1) THEN 0
ELSE FEE_RETL_AM; 


WF: 8201, OS: Windows, Output: HTML, PDF, Excel
 
Posts: 78 | Registered: November 08, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
As crymsyn said, this may not yield correct results..please check your results..
quote:
Originally posted by tlbrydie2:
This is what i needed...thanks

NEW_VALUE/P13.6 MISSING ON = IF (SORC_FEE_ID EQ '04G') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '10X') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '10Y') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '22E') AND (FEE_RETL_AM LT 0.1) OR
(SORC_FEE_ID EQ '04I') AND (FEE_RETL_AM LE .1) THEN 0 ELSE FEE_RETL_AM;


WF 8.2.01 APP STUDIO
PDF,HTML,EXL2K,Active
 
Posts: 127 | Registered: July 21, 2011Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Is this a valid statement

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