Strange Issue with Formula

[frankyberry]

using CR 8.
When I use the below formula, it appears that the formula returns a null, so I'm using the IsNull() to trap it.
If I comment lines 4 & 5, I return "N/A". If I don't it continues to return a null...

any ideas??

whilereadingrecords;
StringVar x;
StringVar Array Places;
Places[UBound(Places)] := {VW_GEO.LOCATIONS}; //Line 4
Redim Preserve Places[UBound(Places) + 1];    //Line 5

If IsNull({VW_GEO.LOCATIONS}) Then
    x := "N/A"

 

[frankyberry]

Let me elaborate on what I want...
The array Places may contain a particular location, if it does, I want it to display "Y", else "N" but if the field {VW_GEO.LOCATIONS} is null, I want it to display "N" as well...

Here is my formula that handles everything fine except nulls...

whilereadingrecords;
StringVar x;
StringVar Array Places;
Places[UBound(Places)] := {VW_GEO.LOCATIONS}; //Line 4
Redim Preserve Places[UBound(Places) + 1];    //Line 5

//If IsNull({VW_GEO.LOCATIONS}) Then
//    x := "N/A"

If "Store" in Places Then
   x := 'Y'
Else
   x := 'N'

 

[dunlop1975]

I've had issues with nulls in the past. try to place the "null trap" at the top of the formula.

whilereadingrecords;
StringVar x;
StringVar Array Places;
If IsNull({VW_GEO.LOCATIONS}) Then
x := "N/A"
else Places[UBound(Places)] := {VW_GEO.LOCATIONS}; //Line 4
Redim Preserve Places[UBound(Places) + 1]; //Line 5


If "Store" in Places Then
x := 'Y'
Else
x := 'N'