Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Does anyone have any ideas? Thanks in advance.
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,
Hi,
Try this expression
=If(GetSelectedCount([Some Other Date]) > 0,
sum({<[Waybill Date]=E([Some Other Date])>}Amount), sum(Amount))
Regards,
Jagan.
Try this one