Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Thanks
First you need to create Fiscal Calendar which starts from Apr (4) -- Mar (3) as FY2017-18 ..
Well ,I had already derived fiscal year from Calendar date ,for example if I select FY2018 ,then It will select
Calendar date from 01-04-2017 to till date value
Sum({<CALDay={"<$(=date(MonthStart(Today()))"}>}Volume)
Regards,
Try, this is the case i would use below one. Min(FiscalMonth) shows Apr.
Sum({<FiscalYear = {">=$(=MonthStart(Min(FiscalMonth))) <=$(=Max(DateField))"}>} Sales)
May be like this
=If(Max({1} TOTAL [Fiscal Year]) = Max([Fiscal Year]), Sum({<CALDAY = {"$(='<' & Date(Max(CALDAY), 'DD-MM-YYYY'))"}>}VOLUME), Sum(VOLUME))