Last Modified Date: 05 Feb 2018
AnswerCreate a calculated field similar to the following and replace the Measure in the view.
IF LOOKUP(ZN(SUM([Measure])),0) = 0
THEN 'N/A' ELSE STR(SUM([Measure])) END
Additional InformationAdditional String formatting may be required because the Measure if effectively turned into a String, so any Integer formatting is lost. More information about this topic can be found in the following Community post: How to replace "No values" [Not Nulls] with N/A
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials