This content has been marked as final. Show 5 replies
Currently we are in FY-2018,December Month ,so if FY-2017 is selected then I need to consider entire year volume (Apr to March),
if FY-2018 is selected then I need to consider only 8 months volume (Apr-Nov),December month volume should not be considered ,In January month ,till December volume I need to considered ....so on
How to write this expression Dynamic from below data
CAL MONTH is derived from a date field as below
Month(CALDAY) as "CAL MONTH"
CALDAY is in DD-MM-YYYY formate