Set expression

[shamitshah]

Hi,

I need an expression to blank the forecast for any month where the date is < today. I only require the forecast for the future months.

In the attached example the forecast bar for July 2017 should be blank.

I tried the expression but it is incorrect:-

Sum ({$<Month={'>=$(=date(today()))'}>}Forecast)

Any ideas?

Thanks

[Anil_Babu_Samineni · Accepted solution]

May be this for forecast

If(Date(MonthName(Today()),'MMM-YY')=Month,' ',Sum (Forecast))

[avinashelite]

Please find the attachment for the solution

[shiveshsingh]

hi

how below expression is excluding past values

If(Date(MonthName(Today()),'MMM-YY')=Month

[Anil_Babu_Samineni]

Haha, May be use sign operations like > and < and >= and <=

[Kushal_Chawda]

try this expression, you need to provide the correct format of month in your set analysis

Sum ({$<Month={">=$(=date(today(),'MMM YYYY'))"}>}Forecast)

[shiveshsingh]

haha..ok ..fine then

[gayatri7]

Try the below expression

Sum ({$<Month={">$(=date(today(),'MMM-YY'))"}>}Forecast)

[neha_shirsath]

Hi,

Try the below expression-

Sum ({$<Month={">=$(=date(today(),'MMM-YY'))"}>}Forecast)

Thanks,

neha

[neha_shirsath]

Only > not >=

corrected -

Sum ({$<Month={">$(=date(today(),'MMM-YY'))"}>}Forecast)