help in set analysis

[Anonymous]

Hi All,

i am calculating  values for YearToGo in set expression.

My requirement is i have calculated MTD,YTD

I am struck wih calculating YearToGo.

I want the sum of values which are not included in the selection.

let suppose I have  months jan to dec .IF i select jan i have value YTD,MTD .

IF i select jan  i need to calculate YearToGo which is sum of Feb to Dec .

Any ideas are appreciated

[#2]

Hi RGV,

try to use

sum({<date={'>= $(SelectedDate) <= $(YearToGo)'}>}Value)

Where date is your date filed,

and SelectedDate is a variable storing the selected day.

and  YearToGo is a variable storing the end of year using YearEnd Function.

be careful to the date format in variables.

hope it is helpful to you.

[#3]

Use the below expression:

Sum(

          {<DateField={">=$(AddMonths(MonthStart(Max(DateField)),1))<=$(AddMonths(MonthEnd(Max(DateField)),12))"}>}           SaleAmount

       )

[Anonymous]

Hi,

try:

Sum({$<Date = {">=$(=AddMonths(MonthStart(Max(Date)), 1))<=$(=AddMonths(MonthEnd(Max(Date)), 11))"}>} Sales)

[Anonymous]

Hi All,

I tried with below expression.

sum({<Month={'>$(vSeletedMonth)'}>}sales)

vSelectedMonth  = max(Month)

Even the above is also working fine .