MTD

[gautik92]

How to calculate the MTD value

[ali_hijazi]

can you please explain in english what do you mean by mtd?

[gautik92]

Month to Date Value Calculation

[its_anandrjs]

Calculate MTD:

=Sum({<DateField={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Metric)

Ex:-

=Sum({<DateField={'>=$(=MonthStart(Today()))<=$(=Today())'}>} SAles)

[gautik92]

Actually This s my YTD

=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=max(Transactiondate))"}>} Qty)

can i modify this for MTD

[its_anandrjs]

Why not you use another expression and you can try this expression

=Sum({<DateField={'>=$(=MonthStart(Today()))<=$(=Today())'}>} Metric)

Or you can try

=sum({<MonthField = {$(=Max(MonthField))},Transactiondate={"<=$(=max(Transactiondate))"}>} Qty)

Regards

Anand

[#7 · Accepted solution]

=sum({<Year={$(=Max(Year))},Transactiondate={">=$(=MonthStart(max(Transactiondate)))"}>} Qty)

[PrashantSangle]

Hi,

Try like

=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=max(Transactiondate))>=$(=monthstart(max(Transactiondate)))"}>} Qty)

or

=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=date(max(Transactiondate)))>=$(=date(monthstart(max(Transactiondate))))"}>} Qty)

or

=sum({<Year={$(=Max(Year))},Transactiondate={"<=$(=timestamp(max(Transactiondate)))>=$(=timestamp(monthstart(max(Transactiondate))))"}>} Qty)

Regards

[#9]

hi gowtham,

yes, you can modify your ytd expression to your mtd expression. just replace year with month. i.e.

=sum({<Month={$(=Max(Month))},Year={$(=Max(Year))},Transactiondate={"<=$(=max(Transactiondate))"}>}Qty)

cheers,

kunal bhattacharjee

[perumal_41]

Hi

Try this

=sum({<Year={$(=Max(Year))},Month={'$(=max(Month))'},Transactiondate={"<=$(=max(Transactiondate))"}>} Qty)