Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi Andy,
try this:
sum ({<NL_Month = {"<=$(vMaxNL_Month')>=$(vMinNL_Month)"} >} NL_Value)
Good luck!
Rainer
Hi Andy,
try this:
sum ({<NL_Month = {"<=$(vMaxNL_Month')>=$(vMinNL_Month)"} >} NL_Value)
Good luck!
Rainer
Rainer
Thank you - this worked fine after taking the stray ' out after vMaxNL_Month!
Cheers