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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement