What is the difference between these set analysis expressions ?

[#1]

Hi all,

I have two text boxes to display the output of following expressions respectively.

1.

=money(Sum({$<[Profit Center]={'216NDD','216OS1'},MonthNumPostDate={$(varPrevCurrMonthNo)},YearNumPostDate={$(varCurrentYear)},WeekNumPostDate={"*"}-{$(varCurrentWeek)}>} [In company code currency POS])) 

2.

=money(Sum({$<[Profit Center]={'216NDD','216OS1'},MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"},YearNumPostDate={$(varCurrentYear)}>} [In company code currency POS])) 

NOTE:

varPrevCurrMonthNo = if(num(Day(today()))<7,$(varPreviousMonth),$(varCurrentMonth))

varCurrentYear = num(Year(Today()))

varCurrentWeek = num(Week(Today()))

Basically i want to know the difference between MonthNumPostDate={$(varPrevCurrMonthNo)} and

MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}

Please explain.

-James

[MK_QSL · Accepted solution]

MonthNumPostDate={$(varPrevCurrMonthNo)}

The result will be based on MonthNumPostDate=varPrevCurrMonthNo

MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}

The result will be based on MonthNumPostDate<=varPrevCurrMonthNo

[#3]

But in the second expression it is MonthNumPostDate={"<= but not MonthNumPostDate<={"=  know ? Then how come it will take all the values of MonthNumPostDate less than the particular month no. ?

-James

[MK_QSL]

in QV set analysis... <= is written by

= {"<="}

[#5]

Ok, Thanks a lot Man !

-Jamy