finding max & Min Month dynamically

[Anonymous]

Hi All,

   I am having a 2 list boxes such as Period 1 & Period 2. So when user selects different months in this list boxes I need to show the delta values between months. For Ex : If user selects Sep 2017 from Period 1 and Oct 2017 from Period 2 ,then I need to show the delta values between these two months.

However if any of the user selects multiple months, I need to show the Max (Month) from Period 2 and Min(Month) from Period 1.

I have attached sample file. Kindly let me know with your solution

Thanks,

Jai

[Clever_Anjos]

you should create your fields as numbers, not text, so you could use something like this

sum({<Month={">=$(=Max(Period1))"}*{"<=$(=Max(Period2))"}>}Value)

[swuehl]

Try like this:

Load your Month values as dates in the script.

Then replace GetFieldSelections() with MinString() resp. Maxstring() in your expressions.