https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545228#M7991 <P>I am using Text box for numeric value with advance filter. If condition is true then numeric value is printed.&nbsp;</P> <P>But when there is no rows with that condition then it is showing (missing).</P> <P>&nbsp;</P> <P>I tried to use new calculated item where I used condition if&nbsp; Val missing then 0 Else Val</P> <P>It is helping to get rid of (missing)</P> Fri, 22 Mar 2019 14:12:13 GMT RahulG 2019-03-22T14:12:13Z https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545228#M7991 <P>I am using Text box for numeric value with advance filter. If condition is true then numeric value is printed.&nbsp;</P> <P>But when there is no rows with that condition then it is showing (missing).</P> <P>&nbsp;</P> <P>I tried to use new calculated item where I used condition if&nbsp; Val missing then 0 Else Val</P> <P>It is helping to get rid of (missing)</P> Fri, 22 Mar 2019 14:12:13 GMT https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545228#M7991 RahulG 2019-03-22T14:12:13Z https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545229#M7992 <P>options missing = 0;</P> <P>&nbsp;</P> Fri, 22 Mar 2019 14:20:57 GMT https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545229#M7992 VDD 2019-03-22T14:20:57Z https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545416#M8022 Where should I write this statement in SASVA reports<BR /> Sat, 23 Mar 2019 03:07:22 GMT https://communities.sas.com/t5/New-SAS-User/SASVA-Text-box-how-to-replace-missing-with-0/m-p/545416#M8022 RahulG 2019-03-23T03:07:22Z