formula to show fulfilled quantity in transaction unit

AI generated answer (using internal Slack threads):

The formula to show fulfilled quantity in transaction units in a saved search can be achieved by using

{quantityshiprecv} / ({quantity} / {quantityuom})

. This formula divides the total quantity shipped/received by the ratio of the quantity to the quantity in transaction units. However, if you want to convert the quantity to the primary stock unit, it can be a bit tricky. If your units naming pattern includes the conversion rate, you can use this formula to get the stock units conversion rate:

NVL(REGEXP_REPLACE({stockunit}, '[^0-9]'),1)

. This formula replaces non-numeric characters in the stock unit with nothing, and if the result is null, it returns 1. You would then divide the quantity in base units by this conversion rate. Unfortunately, if your naming pattern doesn't include the conversion rate, there's no straightforward way to get this in a saved search. SuiteAnalytics datasets do have access to conversion rate, but Saved Searches are unable to pull conversion rate. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******