Set Analysis

[tripatirao]

Hi All

I am having Sales data for year 2011,2012,2013.

I want to find YTD.

Can I use this expression.

YTD Sales (Year To Date)

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=YearStart(Today()))<=$(=Today())’}>} Sales )

[#2 · Accepted solution]

Hi,

i think it works,or else try with this

=sum({<Year={'<=$(=max(Year))'}>}sales)

[lironbaram]

yes

you can use this kind of expression

but it only work for 2015

i

[#4]

Hi tripati,

As Liron said it works only for 2015.

[jonathandienst]

You want YTD data, I assume you also have data for 2015.

I suggest that you test the expression yourself on your data before asking whether it will work.

[MK_QSL]

YTD

SUM({<

     Year =, Quarter = ,Month = , Week = ,

     Date = {">=$(=YearStart(Today()))<=$(Today())"}

     >}Sales)

YTD for selected Date

YTD

SUM({<

     Year =, Quarter = ,Month = , Week = ,

     Date = {">=$(=Date(YearStart(Max(Date))))<=$(=Date(Max(Date)))"}

     >}Sales)

If you want to select Year and get the corresponding sales...

SUM({<

     Date =, Quarter = ,Month = , Week = ,    

     Year = {"$(=Max(Year))"}

>}Sales)

[sunilkumarqv]

=sum({<Year={$(=Max(Year))},MonthID={'<=$(=max(MonthID))'},Month=>}sales)