I am building an Item saved search and when I pull in the "Item Weight" column, it returns "1", representing the base unit (pound) of the "Unit of Measure" table. I need a solution that returns the entered weight (example: 50). Is there a calculated solution leveraging a formula I am unaware of?
Thank you in advance!