Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
Sum( {$ <Year={'$(=Year(Today()) - 1)'} > } Sales)
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
try to add single quotes
'{$(=max([FISCAL YEAR])-1)}'
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)