Saved Search (Quantity Sold Formula)
Hello everyone,
I have a question about the problem I am experience.
Problem with formulas is,
Formula converting or Kit/Package Items and their sold quantity to the single item. Which means,when we sold Kit/Package item for example N9888-99-4 (quantity sold 1) there is exactly 4 quantities. Because that Kit/Package consists of 4 items. And this formula works well for me.
DECODE({item.memberitem},NULL,{item},{item.memberitem})
DECODE({item.memberquantity},NULL,{quantity},{quantity}*{item.memberquantity})
However, I am not able to add any other fields. I tried to add Display Name fields with same formula (example below),and I am not get results as I expected. Display Name does not appears on all items and sold Quantity are not accurate.
DECODE({item.memberitem},NULL,{displayname},{item.memberitem})
Could you be so kind and help me out with this ?
If you any other question please let me know.
Source formula,
http://www.netsuiterp.com/2018/12/saved-search-to-show-quantity-sold-for.html
Kind Regards
You probably want to make your formula have a default value for when an item does not have a display name. You are grouping by display name, so different items without display names will be grouped together.
I would recommend using NVL or NVL2 to return a default value for when the display name is empty. Its makes since to use the original value of {item} as the default.
