topic Re: Displaying data in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723964#M14705 <P>I am using&nbsp;SAS Visual Analytics 8.5</P> Fri, 05 Mar 2021 18:48:47 GMT cokello 2021-03-05T18:48:47Z Displaying data https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723828#M14702 <P>I have a table which has null in some of the cells, how do I make it display 0 in the axis instead of dash, blank or missing?</P> Fri, 05 Mar 2021 10:30:13 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723828#M14702 cokello 2021-03-05T10:30:13Z Re: Displaying data https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723897#M14704 <P>Which version of SAS Visual Analytics are you using?&nbsp;</P> Fri, 05 Mar 2021 16:23:54 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723897#M14704 Madelyn_SAS 2021-03-05T16:23:54Z Re: Displaying data https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723964#M14705 <P>I am using&nbsp;SAS Visual Analytics 8.5</P> Fri, 05 Mar 2021 18:48:47 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723964#M14705 cokello 2021-03-05T18:48:47Z Re: Displaying data https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723971#M14706 <P>You could create an IF/THEN calculated item that returns 0 if a value missing. For example:&nbsp;<BR /><BR />IF ( 'Salary'n Missing )<BR />RETURN 0<BR />ELSE 'Salary'n</P> Fri, 05 Mar 2021 19:17:03 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Displaying-data/m-p/723971#M14706 Madelyn_SAS 2021-03-05T19:17:03Z