Set Analysis Less then

[#1]

Hi all,

I have a set analysis to sum all sales before weeknumber 40 (40 is the result of a variable).

SUM( {$< WeekNumber = { '<= $(vLastWeek)' } >} Amount)

Now it selects all sales before week 40, also when I select in a Listbox weeks 10-20.

Which set analysis should I use?

Thanks!

[swuehl · Accepted solution]

Try the intersection operator:

SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)

[#3]

Thanks, it works!

[jagan]

Hi,

For this try intersection operator * like this, it takes intersection of Current selection and Set Analysis expression

=SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)

Regards,

Jagan.

[Anonymous]

Thanks jagan for explanation i new the use of + and - operator but was not aware

of how * works you made it clear !!

Big Thanks