about YTD

[prabhas277]

Hi,

i want to get the previous years data ,,for example ((=sum({<Date={">=$(=YearStart(today()))<=$(=today())"}>}Sales)) this is logic for current year ..by using this syntax how to get previous year.

Thanks in advance

[amit_saini]

Hi,

1. Current Year

=Sum({$<Month=, Date=, Year={$(=Only(Year))}>} Sales)

or

=sum({<Month=, Date=, Year={$(=max(Year))}>}Sales)

2. Previous Year

=Sum({$<Month=, Date=, Year={$(=Only(Year)-1)}>} Sales)

or

=sum({<Month=, Date=, Year={$(=max(Year)-1)}>}Sales)

Thanks,
AS

[tresesco · Accepted solution]

May be like:

=sum({<Date={">=$(=YearStart(today(),-1))<=$(=AddMonths(today(),-12))"}>}Sales)

[#4]

try like this

=sum({<Date={">=$(=YearStart(today(),-1))<=$(=AddMonths(today()))"}>}Sales)

[prma7799]

Hi Amit,

What is use of =Sum({$<Month=

Thanks

Prashant

[amit_saini]

this is for considering selected Months

Thanks,
AS

[prma7799]

Hi Amit,

Then why we are put blank values

Thanks,

Prashant

[amit_saini]

this will consider all months automatically say for MTD cal.

Thanks,
AS

[prma7799]

means it doesn't accept any value from based on filter we have.

[amit_saini]

Prashantbi,

Please go through this attachment to understand Set analysis.

Thanks,
AS