YTD Expression Issue

[#1]

Hi,

I want to create an expression which will calculate the sum of my dimension from april month of a year to current date.

Thanks,

Utsav

[nirav_bhimani]

Hi,

you are using financial year or normal year?

this work with Fin Year as you want.

In Script // QuarterStart(CalendarDate) as QuaterStartDate,

In Variable //vMaxDate= Max(CalendarDate) OR vMaxDate= (Today())

(sum(
{<
CalendarDate = {">=$(= Date (min({<CalendarWeekOfYear=, FinancialQuarter=, MonthName=>} QuaterStartDate )))<=$(vMaxDate))" }
, CalendarWeekOfYear=, FinancialQuarter=, MonthName=
>}
Sales))

Hope this will help you.

Regards,

Nirav Bhimani.