Non matching records in lookup function should return as Zero instead of '-'
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!!
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').
