Less than in Set Analysis

[#1]

Hi All

I cant find the right syntax for less than in a set analysis. I am having a variable that returns the nr for the open month or max selected month. I want to put this into a set analysis for MonthNr but I cant find the right syntax.

sum({<MonthNr????{$(vMonthNr)}>}Cost)

I am happy for any help.

//Fredrik

[Anonymous · Accepted solution]

Try..

sum({<MonthNr={"<$(=num(vMonthNr))"}>} Cost )

[MK_QSL]

=SUM({$<MonthNr= {'<$(=NUM(vMonthNr))'}>}Cost )

[#4]

Thanks for your reply. It should work fine. I found the right syntax after posting this on the thread. I wrote it like this.

MonthNr={"<=$(vMonthNr)"}

And that worked fine.

[#5]

Thanks for your reply. It should work fine. I found the right syntax after posting this on the thread. I wrote it like this.

MonthNr={"<=$(vMonthNr)"}

And that worked fine.