Return blank in if statement

[gallant09]

I'm try to return a blank if the value is <0 in the following formula. I can get it to return "0", but if I put "" in the TRUE spot, the formula errors out.

IIF (datediff("d",{PJM_MASTER__JOB_CUSTOM_FIELDS.Final_Complete},
if isnull({PJM_MASTER__JOB_CUSTOM_FIELDS.Punchlist_Signoff}) then
currentdate else {PJM_MASTER__JOB_CUSTOM_FIELDS.Punchlist_Signoff})<0,0,datediff("d",{PJM_MASTER__JOB_CUSTOM_FIELDS.Final_Complete},
if isnull({PJM_MASTER__JOB_CUSTOM_FIELDS.Punchlist_Signoff}) then
currentdate else {PJM_MASTER__JOB_CUSTOM_FIELDS.Punchlist_Signoff}))

 

[AndyMc]

Crystal won't allow mixed data types in the results of an if then...

One way to handle this is let the result be 0. Then format the field to supress zero's. Format Field, Customize, and check the Supress if Zero box.

Andy

 

[gallant09]

Supress zeros worked... Thanks!!!!