Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Based on what condition you going to separate customers as Organic and Accquired?
Celambarasan
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.