1 Reply Latest reply: Aug 30, 2012 3:29 AM by whiteline _ RSS

    set analysis problem

      sum({<alt_grp=p(alt_grp),max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)

       

      if have used this expression for getting stock value of material that occur in alt_grp.

       

      i just want that what expression should i used that i get stock of those material that occur in alt_grp as well as

      stock of those material that do not occur in alt_group.

       

       

       

       

       

       

       

       

       

       

       

      -

        • Re: set analysis problem
          whiteline _

          to invert alt_grp selection use:

          sum({<alt_grp=e(alt_grp),max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)

           

          if you have nulls in  alt_grp and want  include such values in the sum use something like this:

          sum({1<max_month=$('v_inventory_Maxmonth'),plant=,material=> -

                   $<max_month=$('v_inventory_Maxmonth'),plant=,material=>}stock)