Saved Search (Quantity Sold Formula)

Hello everyone,

I have a question about the problem I am experience.

Problem with formulas is,

Saved Search Merging

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.




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.



Could you be so kind and help me out with this ?

If you any other question please let me know.

Source formula,

Kind Regards

Rookie Asked on February 10, 2020 in Items.
Add Comment
1 Answer(s)

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.

Advanced Answered on February 11, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.
  • This site made possible by our sponsors:   Tipalti   Celigo   Become a Sponsor   Become a Sponsor