Having define field with P3 which has data want make null on certain condition else should show the value as it is. Since it is P3 in define field I can use zero instead of null. But then How can convert back to null for zero. Cannot use the set tool to make zero to null since all other data zero will convert into null. Only this specific field trying to set to be null for zero. Any idea will be helpful.This message has been edited. Last edited by: Kerry,
WF 7.6.2/ OS WIN2003. DM 7.6.2
August 29, 2008, 03:43 PM
Francis Mariani
Do you want the report column value to be blank when this field is zero? If so, just change the DEFINE to P6S to suppress the zero.
Maybe I'm having difficulty understanding exactly what you require.
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
August 29, 2008, 03:56 PM
Viral
Thanks Francis !
Yes, this the one I was looking for and works fine.
WF 7.6.2/ OS WIN2003. DM 7.6.2
September 01, 2008, 02:26 AM
Tony A
If you really want a "null" and it's a define field then just declare that it equate to a null by -
P3_field/P3 MISSING ON = IF ...... THEN value ELSE MISSING;
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
