Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
Hi,
i think it works,or else try with this
=sum({<Year={'<=$(=max(Year))'}>}sales)
Hi,
i think it works,or else try with this
=sum({<Year={'<=$(=max(Year))'}>}sales)
yes
you can use this kind of expression
but it only work for 2015
i
Hi tripati,
As Liron said it works only for 2015.
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.
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)
=sum({<Year={$(=Max(Year))},MonthID={'<=$(=max(MonthID))'},Month=>}sales)