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())

       

      Thanks,

      AS