Checking Length of Field

[tmumaw]

I am trying to set an indicator based on values in a field.  I have tried all of the following with no luck.  Any ideas?

Thanks
Thom

If (IsNull(KVGR4),1,0) as Organic

If Len(KVGR4 > 0,1,0) as Organic

If (Len(Trim(KVGR4) > 0),1,0) as Organic

[CELAMBARASAN]

Hi,

     Based on what condition you going to separate customers as Organic and Accquired?

Celambarasan

[tmumaw · Accepted solution]

Thanks everyone for your responses, but finally got it to work using this: IsNum([Customer Acquisition]) as Organic.  It made the field either 0 or -1.