Sorry, I am not very clear with your question. But with my understanding you can use the Only() Function. I,e. you can use Only(Lot) as long as you are selecting one date at a time.
Please explain in more detail with example if this not what you need.
In my sample file I have two fields those are Days and Lot
Now i need to display the maximum value of Days field corresponding Lot in a Textobject by default (i don't want to select the maxvalue from the Days field) that means when ever the reloading is happened.
in this i am getting Maxlot for the entire Lot field.But not for the Max(Days).
What i am asking is
If i take max(Days) in a textobject,it will display that max value .similarly for Lot also.
But what i need here is not the Max(Lot) from the entire Lot field.I need only the lot to be displayed for that maxdate in a textobject after reloading the file.
In future my data increases automatically then maxdate changes,so, i can get that corresponding lot in the textobject too.
Ex:
Day,Lot
9-8-11 ,1
10-8-11 ,3
11-8-11 ,5
12-8-11 ,8
13-8-11 ,4
In UI, I mamy take two Textobjects for to display the max(Day) and Max(Day)'s lot(This thing i need).
The problem here is i dont want the maxlot .I want only the Lot for that maxDay.
Hi. In your attached example I understand that you want the textbox to display 21 right?
But what happens if this is your data:
Day,Lot
9-8-11 ,1
10-8-11 ,3
11-8-11 ,5
12-8-11 ,8
13-8-11 ,4 <- SAME DAY, DIFFERENT LOT
13-8-11, 2 <- SAME DAY, DIFFERENT LOT
Do you then want the max(lot) out of the two possible ones on he day 13-8-11?
The only solution I would know to solve this task is by making a small macro macro that is activated after reload (1. select max date, 2. get possbile values from the lot field 3. take the max from those 4. return that max into a variable 5. display the variable in the textbox - but perhaps there is a easier solution?
