1 Reply Latest reply: Apr 18, 2017 5:29 AM by Robin Hausdörfer RSS

    Showing Only Zero or Null Values based on a Variable

    Samir Bihari

      Hi Experts,

       

      I have come across a situation where I need to display only the zero values if a variable is on. Below is the table data and scenario:

       

      SKUDepartmentMonthSales Quantity
      1AutoJan 20174
      2AutoJan 20175
      3ManualJan 20170
      4ManualFeb 20170
      5ManualFeb 20170
      6SemiFeb 2017
      7SemiFeb 2017

       

      I have a variable called NoSales. What I want is if NoSales = 1 , then the table should show only SKU no 3,4,5,6,7 i.e where quantity is 0 or no value.

       

      how I can achieve this?