15 Replies Latest reply: Dec 12, 2014 7:59 AM by Amit Saini RSS

    Sicript help ????

    Amit Saini

      Hi Folks,


      I'm using Pivot table  and I'm looking for solution below:


      if Average Demand  = „0“ and Actual Inventory Available = 0  and Actual Inventory Value= “0” then don’t show the Material number  in the report.



      I'm trying something  like below , but not working


      =IF( not isnull(ACTUAL_INV_VAL) and  not isnull(ACTUAL_INV_QTY)  and not isnull(AVG_DEMAND), Material_MATNR, NULL())