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_AMThis 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
February 21, 2012, 10:21 AM
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;
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
February 21, 2012, 03:30 PM
Crymsyn
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
February 21, 2012, 03:40 PM
BI_Developer
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;