how to convert null values into proper data

[kunkumnaveen]

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])

Thanks

[kunkumnaveen]

i just found out that after removing

[FISCAL YEAR]={$(=max([FISCAL YEAR])-1)}

I am able to fill those null values with data ,but according to requirement I need to show previous year values all the time

so is there any thing gone wrong with my syntax..

[Chanty4u]

Sum( {$ <Year={'$(=Year(Today()) - 1)'} > } Sales)

[kunkumnaveen]

HI ,thanks for your reply,

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

this is my expression ,what i need to change

[Chanty4u]

try to add single quotes

'{$(=max([FISCAL YEAR])-1)}'

[sunny_talwar]

Try these

Spend

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

Total Spend:

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

Total  volume:

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