Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Try the intersection operator:
SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)
Try the intersection operator:
SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)
Thanks, it works!
Hi,
For this try intersection operator * like this, it takes intersection of Current selection and Set Analysis expression
=SUM( {$< WeekNumber *= { '<= $(vLastWeek)' } >} Amount)
Regards,
Jagan.
Thanks jagan for explanation i new the use of + and - operator but was not aware
of how * works you made it clear !!
Big Thanks