User Date selections for Set Analysis not adequate..need help

[#1]

I have a Set Analysis expression that works great under strict circumstances.

This sums up a Date Range from Min to the Max Months selected. or Max(RevMonth)

Sum({$<RevMonth={"$(='>=' & Min({$} RevMonth) & '<=' & AddMonths(Min(RevMonth),MonthDiff) )"}>} RevAmt) 

The problem is if a user selects Non Consecutive months then the calculation is wrong or sums up to much because it does not take into account the 'missing' months.  Is there a better way to handle this situation.?  What I'm I doing wrong ?

Thank You all,

Brian

[m_woolf]

Can you use max(RevMonth) instead of

AddMonths(Min(RevMonth),MonthDiff)

[#3]

Yeah I've tried that, but gets me the same result. I may have to provide all the possible month possiblities up to 20 or so. too much work but may require that or force them to only select Consecutive months which is how most would any ways.

[johnpaul · Accepted solution]

I don't let the user select multiple months.

I use a variable and a calendar object to allow the user to select an end date. Then another variable to select the start date.

[#5]

I think that is the way I will have to do it to control the data flow into the Expression.

Does it allow user to see whats green,grey white, I guess that implied once selected...

Thank you both for your insights, tips & advice.

[#6]

Paul, could you upload a sample of this calendar method with variables or point me to a online example.? Thanks!

[kaushiknsolanki]

Hi,

     Have a look at the attachment.

Regards,

Kaushik Solanki