How to Calculate MTD

[#1]

Dear All

How can I put the expression to calculate MTD? I have the following columns in the pivot table:-

				Today				MTD
			DChl	DC	DE	IT	Total	DC	DE	IT	Total
Plant	Group	SO Name	MCounty				Total				Total
NE02	AGKNG	AGK	Ahmedabad	209.470	212.000	502.000	923.470	-	-	-	-
NE02	AGKNG	AGK	Gandhinagar	17.180	44.000	NIL	61.180	-	-	NIL	-
NE02	AGKNG	AGK	Kheda	17.000	129.000	NIL	146.000	-	-	NIL	-

[matt_crowther]

In the past I've used: (unchecked syntax)

=sum(if(monthname(DateField)=monthname(today()) and date(DateField)<=date(today()),Sales))

Alternatively of course you can use the InMonthToDate() function.

Hope that helps,

Matt - Visual Analytics Ltd