topic Re: MTD and YTD in Management & Governance

MTD and YTD

laxmanqlik — Tue, 16 May 2017 10:50:35 GMT

can anyone let me know where can i find the complete info on how to work with MTD and YTD.

and how to calculate the values of MTD and YTD.

Re: MTD and YTD

sanjay006 — Tue, 16 May 2017 11:00:53 GMT

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

Re: MTD and YTD

sanjay006 — Tue, 16 May 2017 11:01:39 GMT

YTQ, QTD, MTD and WTD

you can refer this also