I have the following formula.  I am having to upgrade our MRP system and one of my custom reports has the following error in this code (the red highlighted section:  the string is non-numeric - how do I put in a if null then 0 statement to this?


NumberVar  CAT4;
IF {SY0_CompanyParameters.ARAgeByDayOrMonth} = "D" Then
    NumberVar  CAT4:=ToNumber({SY0_CompanyParameters.ARAgingCategory4})
Else     NumberVar CAT4:=120 ;

IF {@agedate}-{@InvOrDueDate} >= NumberVar CAT4 THEN
{AR_OpenInvoice.Balance}
ELSE
0.00

I've tried    

NumberVar  CAT4:=if (isnull({SY0_CompanyParameters.ARAgingCategory4}))then 0 else(ToNumber({SY0_CompanyParameters.ARAgingCategory4}))
Else     NumberVar CAT4:=120 ;

still get the same error



Edited by chudok - 27 Jun 2011 at 9:15am

I am not sure how to do that.... can you help direct me in the right direction?  It's been a while since I've used Crystal and I am a little rusty......

All I get back are blanks(null?).  When I browse the field data it comes back as String Type Length: 3

Not sure where to go from here.....

Did that - same problem still "The string is non-numeric"

Leave it at Crystal Syntax too?

The only tool I currently have to this database is Crystal.  IT does not even have excel out there where I can use that to query the db. I do not have access to SQL either.....

If I can get IT to create a connection to excel will that work for what you are looking for me to do?