Null Formula

[dunkyn]

Newbie question...what is the correct way to serve for a null (blank) ? I receive errors on the first line ...looking for the word then...

If Isnull {POSITION_DG.TRM_TO_MAT_RTE} then "0 - 1 Year"
Else If
If {POSITION_DG.TRM_TO_MAT_RTE}>15 Then "15+ Years"
Else If
{POSITION_DG.TRM_TO_MAT_RTE}>10 Then "10 - 15 Years"
Else If
{POSITION_DG.TRM_TO_MAT_RTE}>5 Then "5 - 10 Years"
Else If
{POSITION_DG.TRM_TO_MAT_RTE}>3 Then "3 - 5 Years"
Else If
{POSITION_DG.TRM_TO_MAT_RTE}>1 Then "1 - 3 Years"
Else If
{POSITION_DG.TRM_TO_MAT_RTE}>0 Then "0 - 1 Year"
else
" "

TIA

 

[takure]

Try removing the IF in your Else If statement.

 

[dgillz]

You also need parens with your IsNull() statement.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[Madawc]

As Dgillz said, the format for nulls is
isnull ({what.ever})
You can also say not isnull. But you're right to put it first, a formula field will vanish like a boojum if it finds a null that has not been tested for.

As takure said, your 2nd and 3rd lines are
Else If
If {POSITION_DG.TRM_TO_MAT_RTE}>15 Then "15+ Years"
i.e. you have if if, not a possible command in Crystal



Madawc Williams
East Anglia
Great Britain