Taina, which "help instruction" did you follow? Please provide a link. Thanks,
1 of 1 people found this helpful
The N/A is not appearing because there is NO data, not null data in the data. A similar result can be achieved by creating a calculated field similar to the following:
if zn(lookup(sum([Number of Records]), 0))=0 then "N/A" else str(sum([Number of Records])) end
Hope this helps!
Thanks for your quick and helpful response. I will test your solution with real data. Also, preparing Excel source data by exluding empty columns might be a solution to this.