Non matching records in lookup function should return as Zero instead of '-'

[bharani8]

Hello Experts - I believe it will be simple for you... I have performed an lookup function and for the non-matching records(records which is available in one table but not in other table) i like to get the number as Zero instead of "-" symbol.. Please Help!!

[marcus_sommer]

Lookup provides no alternative value by a non-matching of the values. Therefore you need to wrap the lookup with alt(lookup(), 0) or rangesum(lookup()) when the values are numeric and by string-values you could use an if(len(lookup())>0, lookup(), 'some other value').

An alternatively to a lookup might be a mapping with applymap: Mapping … and not the geographical kind.

- Marcus