Set analysis help in calender

[dhanu_today]

Hi Everyone,

I have to derive two expressions like A and B with following conditions in the design level with the set analysis is added an advantage.

1)If am selecting FIN_YEAR(2014),CAL_MONTH(March) then A has to show the accounts opening date till March 2013 and B has to show 04/01/2013 to 03/31/2014

If am selecting FIN_YEAR(2015),CAL_MONTH(April) then A has to show the accounts opening date till April 2014 and B has to show 04/01/2014 to 04/30/2014

2) If am selecting FIN_YEAR(2014),CAL_MONTH(March) then A has to show the accounts opening date till March 2014 and B has to show remaining accounts.

The sample data has been attached .

Thanks in adv,

Dhanu

[#2]

Hi dhanu,

May be it will help you,

do following step:

1)  QuarterStart(ACCOUNT_OPENING_DATE) as QS,

2) Expression for condition :

only({<ACCOUNT_OPENING_DATE = {">=$(=(Min({<CAL_MONTH=>}ACCOUNT_OPENING_DATE)))<$(=date(max(QS,5)))"},FIN_YEAR=, FIN_QTR=, CAL_MONTH=>} ACCOUNT_OPENING_DATE)

Thanks & regards,

Harshal Patil

[dhanu_today]

Thanks for your time Harshal .Its working in alternate way also.

Dhanu