Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
For 201706 i need to show sum of volume from 201704 to 201705 only which is -700-200+700+1700-1700+2200==2000 so i need to 2000
please suggest how to write a expression to achieve above requirement
thanks
May be this?
Sum({<CALMONTH = {'201704','201705'}>} VOLUME)
Or
Sum({<CALMONTH = {">=$(=Max(CALMONTH)-2) <$(=Max(CALMONTH))"}>} VOLUME)
Only for 201706? What about other CALMONTH?
It is dynamic or hardcoded value let me know.
thanks for ur quick reply,s
Sorry i think, i haven't clearly explain this requirement
what if 201710 is selected
then i need to show volume from 201704 to 201709
currently i need to show only 201706 but it has to be dynamic what i mean what i mean is
for 201710 i need to show sum of volume from 201704 to 201709
That mean you only need current month of data? May be this?
Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=Max(CALMONTH))"}>} VOLUME)
currently i need to show only 201706 but it has to be dynamic what i mean what i mean is
for 201710 i need to show sum of volume from 201704 to 201709
For 201710 May Be it is 201708 to 201709
Try this it is dynamic and based on selection as well
Sum({<CALMONTH = {">=$(=Date( Addmonths(Max(CALMONTH),-2 ),'YYYYMM' ) <$(=(Max(CALMONTH))"}>} VOLUME)
And may be this
Sum({<CALMONTH = {">=$(=Date( Addmonths(Max(CALMONTH),-2 ),'YYYYMM' )
<$(=(Date(Max(CALMONTH),'YYYYMM')"}>} VOLUME)