Set analysis with date between

[#1]

Hello, guys!

I have a problem with set analysis, I need to create an expression with the average of values for the period from January till Month picked by user in the filter.

I created and expression: AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date)"},Month_name=>}(Bench_Data*Forecast)), but it's not working,

May be I have some syntax error?

Please help!

Sample app is attached

[marcus_sommer]

You have a 1 within the set analysis which meant to ignore user selections. You need to remove it:

AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date)"},Month_name=>}(Bench_Data*Forecast))

- Marcus

[swuehl]

There is just a closing bracket missing:

AVG({<Month_Date={">=$(=Min({1}Month_Date))<=$(=Max(Month_Date))"},Month_name=>}(Bench_Data*Forecast))

Not sure if the logic is correct since min Month_Date is Jan-14.

[#4]

Yes, You're absolutely correct. It's not right, I need to set as min date Jan-15.

How can I insert this condition in my Set analysis?

[swuehl]

Not sure, maybe like

AVG({<Month_Date={">=$(=Date(yearstart(today()),'MMM-YY'))<=$(=Max(Month_Date))"},Month_name=>}(Bench_Data*Forecast))