1 of 1 people found this helpful
Change the formula to below.
[Avg Overdue Appts (copy)]
zn(lookup(sum([Overdue Appts]) / [Count District],0))
[Avg Overdue Appts]
sum([Overdue Appts]) / [Count District]
At least in the X-table, it shows Zero instead of blank.
Easy enough, thank you again! I'll keep the ZN function so the zero is displayed.
You are very welcome.
Easy enough as long as you know it!!