March 11, 2015, 01:13 PM
Francis Mariani[SOLVED] SUM on a DEFINE column not preserving MISSING
I have a DEFINE column with MISSING ON, and the IF statement setting it to MISSING for certain conditions.
With SUM, the Excel report shows the value as zero, not blank. If I use the real, not DEFINE column, the value is shows as blank.
D_INITIAL_AMVALUE_PBD/D22.2 MISSING ON = IF LOAD_DTE_PBD GT '&I_MIN_LOAD_DTE_PBD' THEN MISSING ELSE INITIAL_AMVALUE_PBD;
This message has been edited. Last edited by: Francis Mariani, 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
March 11, 2015, 01:35 PM
Francis MarianiI should have searched FocalPoint before posting!
Thank you
Benelux Dave for the answer!
D_INITIAL_AMVALUE_PBD/D22.2 MISSING ON NEEDS ALL DATA = IF LOAD_DTE_PBD GT '&I_MIN_LOAD_DTE_PBD' THEN MISSING ELSE INITIAL_AMVALUE_PBD;
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