1 Reply Latest reply on Oct 12, 2012 9:02 AM by Tracy Rodgers

    How to replace missing values in data with 0

    Archana Amarnath

      Hi,

       

      I have a dataset for products and their corresponding sales at a year level. Some products are present in both the years (previous and current). Some are there only in current year and vice versa.

      When i display these products and their sales, for the products which are not there in current year, sales column has missing values. When i sort the data by descending order of sales, the products with no sales in current year ( missing value rows) come at the last. Hence my bottom products come as these. But i want the products with actual low sales to be shown as the last products. Is there a way by which i can replace these missing values with 0s?

       

      I am attaching a sample dashboard for reference.

       

      Referring to the dashboard - Dairy Milk should come in the end.

       

      Thanks,

      Archana