one of our standard reports has the plurality of a word indicated as adding an s if the quantity of the field value is greater than 1. This is fine for most words, but for the packing element of box is should be “es”. Is there a way to show this easily, or would it be better to change box to carton?
“Total “+Sales_orders.Packing.Manner_of_packing.Unit_2_description+if(val(External$(”$SQL select count(sku__ref) from afgsku__ where lyn__ref ='”+Sales_orders.ID+“'”))>1,“s”)
Hello,
One option would be to set up a condition here, but this would quickly become confusing if there were several words with this same issue.
This behaviour is not actually caused by List & Label. One alternative would be to use an SQL table containing the correct plural forms that can be accessed.
thanks, I think this works easiest, as we have a limited # of variables for this field.