Fiscal year YTD and FY expression

[chintu94]

Hello Experts,

I have to show the values of Fiscal year YTD and Fiscal Year, where my fiscal year start from the month April to March.

I want Dynamic expression for FY-YTD and FY..

I have written an expression but it is not working properly 

FY_YTD: Sum({< Datefield={">=$(=addmonths(Yearstart(Max(Datefield)),3))<=$(=Max(Datefield))"}>}Sales)

FY: Sum({<Datefield={">=$(=addmonths(Yearstart(Max(Datefield)),3))<=$(=Monthend(addmonths(Yearstart(Max(Datefield)),14)))"}>}Sales)

Please suggest me the expression

Thanks in Advance

[Dalton_Ruer]

Search for Master Calendar you will find a plethora of ways to add flags like "FYTD" "PFYTD" etc. Goal is to handle that kind of CPU activity 1 time during the load so that the front end will fly.