5 Replies Latest reply: Jul 12, 2017 7:23 AM by Sunny Talwar RSS

    how to convert null values into proper data

    naveen kumar

      Hello, can any one let me known why i am getting null values even though there is a data

       

      Dimensions :New_Column,PLANT NAME,plant code,inte,int,volume,unit price

      Expression: i used

      Spend:

       

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

       

      Total Spend:

       

      aggr(nodistinct Num(Sum({<SCOPE={'Yes'},MATL_TYPE={'HALB','ROH'},[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}>}SPEND),'₹ #,##0 '),New_Column,[PLANT NAME])

       

      Total  volume:

       

       

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

      Totalspend.png

      total.png

       

      Thanks