MTD :
((Sum({<FYear={"=max(FYear)"}, MONTH1=, Quarter=,DATE_SLIPDATE1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE))))<=$(=Max(NUM_DATE))"}>} ACCOUNTED_CR)- Sum({<FYear={"=max(FYear)"}, MONTH1=, Quarter=,DATE_SLIPDATE1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE))))<=$(=Max(NUM_DATE))"}>} ACCOUNTED_DR)))/1000000
YTD:
sum({<DATE_SLIPDATE1=,YEAR=, MONTH1=, NUM_DATE={">=$(=Num(MonthStart(Max(NUM_DATE),-11)))<=$(=Max(NUM_DATE))"}>}ACCTD_AMOUNT)/1000000
* this is for the financial year starts with Apr and ends at Mar
