how to write expression

[kunkumnaveen]

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

[kunkumnaveen]

Sum({<CALMONTH = {">=$(=YearStart(Max(CALMONTH))) <$(=Max(CALMONTH))"}>} VOLUME)

the above expression is working bang on but only one thing is if i am have from 201701 to 201708

and for 201709 i need to show  sum of volume from 201704 to 201708  but now it is showing sum of volume from 201701 to 201708 .....

how to get sum of volume from  201704 to 201708

how to write expression

[Anil_Babu_Samineni]

Is your fiscal year starting from April? If not you can manipulate to work.. Or else i believe you have to declare static only