Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I want to replace a field values like - , Null or 0 by 1. which function should i use to replace Null or 0 value by 1 ?
Thanks & Regards,
May be like this
If(Field = 0 or IsNull(Field) or Len(Trim(Field)) = 0, 1, Field) as Field
If(Match(Field,0,'-')>0 or IsNull(Field) or Len(Trim(Field)) <1, 1, FieldName) as FieldName