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

    total grouping expression

    naveen kumar


                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


      after selecting material the total spend is correct


      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