Formula to convert the amount from the base unit to the primary unit in an item saved search

  • Navigate to Lists > Search >Saved Search > New, then select item search.
  • Provide the criteria and results as per the requirement.
  • Under the results tab, select ‘Formula(currency)’
  • Select summary type as ‘Maximum’
  • Provide the formula: MAX(({transaction.rate}*{transaction.quantity})/{transaction.quantityuom}) KEEP(DENSE_RANK LAST ORDER BY {transaction.trandate} )
  • Then save and run the search

Leave a comment

Your email address will not be published. Required fields are marked *