Skip to Content
0
Dec 20, 2013 at 07:34 AM

Current Financial year Custom Count

29 Views

HI,

i need requirement Current and last financial Custom Count,

[Visit].[L01 Cal. year / month] is having two years of data,following values

04.2012

05.2012

.

.

11.2012

.

04.2013

05.2013

..

11.2013

i have to take Current FinanCial year Custom Count that is 04.2013 to 11.2013 Dynamically

have applied following formula

=Count([Customer/Prospect ID Key])Where([V_Year Conversion]="2013" And [VV_visit Callmonth]>=4 And [VV_visit Callmonth]<=12 )

it is giving wrong Count 14293,Actaul Count is 2982

[VV_visit Callmonth] variable having formula

=ToNumber(Left([Visit].[L01 Cal. year / month];2))

[V_Year Conversion]

=FormatDate(ToDate([Visit].[L01 Cal. year / month];"MM.yyyy");"yyyy")

plz help, find the Screen Shot,,

Attachments

Customer.JPG (104.5 kB)