topic Re: Previous Fiscal Year Expression Issue in App Development

Previous Fiscal Year Expression Issue

Fri, 02 Sep 2016 15:01:05 GMT

I am using the YTD expressions found in these posts, with slight modification for the fiscal year starting July-1: YTQ, QTD, MTD and WTD Previous YTQ, QTD, MTD and WTD

My Fiscal YTD set analysis expression is the following, this works perfectly

{$<Year=, Month=, Date=, DateNum={">=$(=Num(YearStart(Max(DateNum),0,7)))<=$(=Max(DateNum))"}>}

My Previous Fiscal YTD expression doesn't work at all - I'm assuming its a syntax error as the set analysis doesn't restrict data at all when its used.

{$<Year=, Month=, Date=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1,7)))<=$(=AddYears(Max(DateNum),-1))"}>}

Could anyone take a look at these expressions and tell me what is wrong with the second one?

Thanks for the help!

Re: Previous Fiscal Year Expression Issue

sinanozdemir — Fri, 02 Sep 2016 15:47:34 GMT

Hi,

It seems like your DateNum field is not formatted as date. If so, try the below:

{$<Year=, Month=, Date=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1,7)))<=$(=Num(AddYears(Max(DateNum),-1)))"}>}

Hope this helps.

Thanks

Re: Previous Fiscal Year Expression Issue

sunny_talwar — Fri, 02 Sep 2016 15:50:06 GMT

May be this

{$<Year=, Month=, Date=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1,7)))<=$(=Num(AddYears(Max(DateNum),-1)))"}>}