Table monthly

[soniasweety]

Hi all,

I want to count the numbers  MTD on  strightable

I have a datefield like

Num(Floor(Createdate)) as createDateNum,

how to get MTD for this ? how to write the expression for this?

Thanks

sony

[tripatirao]

Please share what you  want calculate from this date field.

Is it monthname of the date .

Share some sample data

[thevingo]

Hi

Try this, if you want to calculate MTD for Sales, Sum({<createDateNum={">=$(=Num(MonthStart(Max(createDateNum))))<=$(=Max(createDateNum))"}>} Sales)

Also you can refer to

YTQ, QTD, MTD and WTD

[shiveshsingh · Accepted solution]

May be this

sum({<createDateNum = {">=$(num(monthstart(max(createDateNum))))<=$(=max(createDateNum) )"}>}Quantity)

[soniasweety]

am using same but I am getting the result    jan-05-2018 

but MTD means  max month data should come right?  means march?

[shiveshsingh]

Can you share your app?