How to display qty total with different UOM using BEx query?

[Private_Member_82764]

Dear all,

I am working on BEx query. I am using 0IC_CO3 to create a query to show 0TOTALSTCK for the qty stock balance. I have 2 questions:

(1) Since our materials have more than one UOM and I donu2019t want to convert to one UOM, I want to show the total under different UOM. Currently the total line will show * because it adds up the qty with different UOM. Is anyway I can show the total under different UOM, like EA, LB, L, CAS for 0TOTALSTCK?

(2) I donu2019t want to convert the UOM and is anyway I can ignore different UOM to add up all qty with different UOM to show one number in the total line without UOM? pretty much like the LIS inventory analysis (MC.1) report to add up all qty regardless of UOM but it wonu2019t show the UOM at the total.

Thanks

[Former Member · Accepted solution]

Hi,

Use NODIM() function.

Regards,

-Vj

[Former Member]

There is a formula called NODIM() to hide UOM, but I don't know how to hide UOM just for the result row.

You can bring UOM into characteristics column, and then show subtotals at UOM level. I think grand total row will still show * for UOM.

___

Sudhi Karkada

<a href="http://main.nationalmssociety.org/site/TR/Bike/TXHBikeEvents?px=5888378&pg=personal&fr_id=10222">Biking for MS Relief</a>