Greater than or less than a Variable in set analysis

[jananireddy]

Hello,

I am trying to do a condition to achieve results greater than and less than a particular period (In the format YYYY-MM)

count({<Sales_Month_Year ={">=$(=vMinSalesPeriod)<=$(=vMaxSalesPeriod)"}>} ID)

This does not work for me. My data looks this way:

Sales_Month_Year

2018-01

2018-02

.

.

and so on

And the Variable are captured in the format same format. How ever this works for me

count({<Sales_Month_Year = {"=$(vMinSalesPeriod)"}>}VIN)

But the moment i put a greater sign in that statement it shows 0 records

count({<Sales_Month_Year = {">=$(vMinSalesPeriod)"}>}VIN)

Thanks in advance

Janani

[Nicole-Smith]

What about without the extra = signs in the dollar sign expansion?

count({<Sales_Month_Year ={">=$(vMinSalesPeriod)<=$(vMaxSalesPeriod)"}>} ID)

Also, maybe try wrapping the dollar sign expansions in single quotes if your variable value is a string:

count({<Sales_Month_Year ={">='$(vMinSalesPeriod)'<='$(vMaxSalesPeriod)'"}>} ID)

[jomar_ebonite]

Hi,

FYR.

=Sum({$<Year = {">=2013 <=2015"}>} Amount)

(intersection between section and current year)

Or this:

Sum({$<Year = {">=2013 <=$(=Year(Today())-2)"}>} amount)

Thanks.

[balabhaskarqlik]

May be this:

count({<Sales_Month_Year ={">=$(=$(vMinSalesPeriod))<=$(=$(vMaxSalesPeriod))"}>} ID)

[jananireddy]

Thanks Jomar, Helps me realize one thing with this

count({$<Sales_Month_Year = {'>=2018-02 <=2018-10'}>} VIN)

This does not work for me, seems like a format issue.

[jananireddy]

Hi Nicole, I am using something as basic as this expression to check if the format is being read correctly

count({$<Sales_Month_Year = {">='2018-02'"}>} VIN)

Does the above statement make sense, I have passed the period in quotes but does not work

[jananireddy]

Hi, this did not work either for me

Thanks

Janani

[jananireddy]

Hi Guys,

I am still trying to understand why does this work for me

count({$<Sales_Month_Year = {'=2018-10'}>} VIN)

and this doesn't

count({$<Sales_Month_Year = {'>=2018-10'}>} VIN)

[DavidŠtorek]

Hi,

is field Sales_Month_Year string or is it number? It seems that it is probably string because than it is not possible to make >= comparison.