#missing appearing in report even though data replacement is #NumericZero
Summary#missing appearing in report even though data replacement is #NumericZero
we are using smart view version 710. Our users recently notice something with the function report when refresh.
Even though they have selected smart view options > Data options > Replacement > @NoData/Missing label as #Numericzero, upon the first refresh of the report, #missing will still appear. They need to refresh a second time again to get back 0 instead of #missing. If they open the file for a while like 15 min long, #missing will pop up again and they need to refresh the report all over again.
Does anyone know how to get around this?