Skip to Content
0
Former Member
Sep 30, 2010 at 04:01 PM

Case Statement with Isnull

263 Views

Hi gurus,

I am in process of converting a forumla field from Crystal report to Universe Objects. Please help me out in converting

if {?Dept}="NONE" then "NONE GRP" else

if isnull({CLARITY_DEP.DEPARTMENT_ID}) then "Unknown Department" else

if isnull({CLARITY_DEP.DEPARTMENT_NAME}) then "No Name for Department # " + totext({CLARITY_DEP.DEPARTMENT_ID},0,"") else

{CLARITY_DEP.DEPARTMENT_NAME} + " - " + totext({CLARITY_DEP.DEPARTMENT_ID},0,"")

Thanks in Advance

Regards

R