excluding current selections

[#1]

I have a text box representing max(orderdate) , I need to keep it constant depending on the latest order....but when I am making other selections the order date is changing....so I need to use set analysis to exclude current selections.....Can anyone please post me code for my expression to exclude current selections.....

[alexpanjhc]

I would do it in my script with a variable and put that variable in the text box. That way you do not need to bother what is selected in the selction box.

Does that help?

[#3]

I tried using variable in script as

set $(variable) = max(Orderdate);

I am getting an error  aggregation expression cannot be used in group by....

[alexpanjhc]

you can't use that way.

do it like this:

test:

select max(orderdate) as Max

from ordertable;

Let vMaxDate = Peek('Max',0,'Test');

[Nicole-Smith · Accepted solution]

To do it in the text box, just do max({1}orderdate).  The {1} tells it to ignore all selections.

[#6]

Thankyou, Its working perfect....