It's the other way around, size is highest, since the expression is:
allt(iif(sizeorder=1,size,''))
It will give me the size I'm looking for in one case only, for all the other sizes it will return an empty string, so that seemed like the simpler way to pull the value out.
The stock is a sum, but I could have also used highest since the value will be larger than zero just once for each size. Is it working now?
>Yes, I have did it.
>BTW, Why you set the sizefield to sum and stock to highest?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only