Fiscal year YTD and FY expression

chintu94 — Thu, 01 Apr 2021 13:46:08 GMT

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

Re: Fiscal year YTD and FY expression

Dalton_Ruer — Wed, 21 Apr 2021 19:04:05 GMT

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.

topic Fiscal year YTD and FY expression in App Development

Fiscal year YTD and FY expression

Re: Fiscal year YTD and FY expression