Set Analysis - Exclude selected items from Calc

[nsm1234567]

Hi There,

I've been working on a solution to exclude values that are selected in a listbox from a calculation.  The attached works correctly, however, it doesn't seem very elegant to me (it relies on a variable to adjust the set analysis and you also get the squiggly line, which I prefer to avoid).  Can anyone think of a better way to do this?  The idea is that:

• When "some other date" dates are selected, those dates should be excluded from the calculation
• When no "some other date" selected, there should be no exclusions from the calculation.

Does anyone have any ideas?  Thanks in advance.

[arasantorule]

Hi,

I hope this will give you the solution.

=if(GetSelectedCount( [Some Other Date])>0,sum({$<[Waybill Date]=E({$}[Some Other Date])>}Amount),sum(Amount))

Thanks,

[jagan]

Hi,

Try this expression

=If(GetSelectedCount([Some Other Date]) > 0,

sum({<[Waybill Date]=E([Some Other Date])>}Amount), sum(Amount))

Regards,

Jagan.

[vipin_mishra479]

Try this one