Using a Max and Min Date Variable in set analysis

[#1]

I can't seem to get this set analysis working. I'm selecting a range of months from a list box and using two variables to get the maximum and minimum dates from my selection.

If I use them in the following expression I find the minimum formula works fine but the maximum formula is not working and if I reverse the formula the maximum works fine and the minimum doesn't!

sum ({<NL_Month = {'<=$(vMaxNL_Month'), NL_Month = {'>=$(vMinNL_Month)'} >} NL_Value

Any suggestions in how to pick up just the NL_Value between the minimum and maximum month?

[#2 · Accepted solution]

Hi Andy,

try this:

sum ({<NL_Month = {"<=$(vMaxNL_Month')>=$(vMinNL_Month)"} >} NL_Value)

Good luck!

Rainer

[#3]

Rainer

Thank you - this worked fine after taking the stray ' out after vMaxNL_Month!

Cheers