Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
-
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)