Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
MonthNumPostDate={$(varPrevCurrMonthNo)}
The result will be based on MonthNumPostDate=varPrevCurrMonthNo
MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}
The result will be based on MonthNumPostDate<=varPrevCurrMonthNo
MonthNumPostDate={$(varPrevCurrMonthNo)}
The result will be based on MonthNumPostDate=varPrevCurrMonthNo
MonthNumPostDate={"<=$(=varPrevCurrMonthNo)"}
The result will be based on MonthNumPostDate<=varPrevCurrMonthNo
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
in QV set analysis... <= is written by
= {"<="}
Ok, Thanks a lot Man !
-Jamy