Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
how can we write expression for current year sales(chart should change dynamically for next year?
Dynamically for next year means
Sum({<Year = {'$(=Max(Year))'}>}Sales) // It will give 2017 data sales if you have till 2017 data. In future, If you are adding or updating for next year it will return 2018 data point of sales
Sum({<Year = {'$(=AddYears(Max(Year),1))'}>}Sales)
May be this
Sum({<Year = {"$(=Year(Today()))"}>} Sales)
Sum({<Year = {'$(=Max(Year))'}>}Sales) //// it shows the 2018 year.I didn't get 2017
if i write this expression sum({$<Year={$(=max(Year)-1)}>}Sales) //// i get 2017 year,what is the reason. plz tell me
Gopichand
May be you have forecast data for 2018 too.