I have the following expression set up in my master calendar for the Fiscal YTD which returns either a 0 or 1 in the results.
InYearToDate(TempDate, $(varToday),0,4) *-1
I can use this field in set analysis and set it to either a 0 or 1, should I want to calculate the current financial year. The 1 currently returns Apr-16 - July-16 data for me
I admit that I copied this syntax from a previous post and now I want to be able to understand it more as I want to adapt it so I can get the previous Financial YTD
I am looking to adapt the syntax so I can get results for Apr15-Jul15 when I set it to 1
