YTM Calculation

[#1]

Hello,

I want to calculate YTM target.

Eg. If user select April month then FTM and YTM will be same. but when he select May there should be addition of 2 months target i.e April & May

For The Month(FTM) Expresion

=Count({<NDATE={">$(vMaxUDate)","NULL"},JDATE={"<$(vMaxUDate)"}>}distinct ET)*NOAUDIT

YTM Expression

=if(MONTH='Apr',count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={1},NDATE={"NULL"}>} distinct ET)*NOAUDIT,

if(MONTH='May',(count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={1},NDATE={"NULL"}>} distinct ET)*NOAUDIT)

+

(count({<JDATE={"<=$(vMonthEnd)"},CY={"$(vMaxYear)"},CN={2},NDATE={"NULL"}>} distinct ET)*NOAUDIT))

where vMaxUDate=max(DATE) is Unlink date

CY is year, CN is Monthnum I am passing 1 in CN for April Month and 2 For May Month

Need help !!!