7 Replies Latest reply: Aug 2, 2017 7:56 AM by Anil Babu RSS

    total grouping expression

    naveen kumar

      Hello,

                i am getting different  total spend value  before selecting any material and after selecting ,the values i am getting  after selection is correct values

      before selecting any material  all the total spend is wrong

      Capture.PNG

      after selecting material the total spend is correct

      Capture1.PNG

      expression i wrote for total spend is

       

      Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}total<New_Column,[PLANT NAME]>SPEND)


      New_Column labeled as Material

       

      i think something is going wrong in my expression .How to make same values to appear even before selecting any material as i am grouping with material and plant name



      thanks