I have an issue that may be an easy fix for someone, but is not for me.
I need to calculate Instock%. For this I need to take p.QTY (Forecast Demand) / s.OH (What is on hand) and get a percentage.
For example p.QTY (Forecast) was 2 and Inventory On Hand is 100 now so I need to get 2% as a result.
However, when I just divide p.QTY / s.OH AS 'Instock %' I simply get a 0.
SELECT s.OH AS 'Inventory On Hand', P.QTY AS 'Forecast Demand (sales order)', p.QTY / s.OH AS 'Instock %' FROM SCPOMGR.SKU s JOIN SCPOMGR.PLANARRIV P ON S.ITEM=P.ITEM AND S.LOC=P.DEST
Does someone know how I can format or change the way I divide so that I get a %.
Thank you very much in advance!!
ps. I use SQL Server Management Studio.
- This topic was modified 1 month, 1 week ago by JeremyU.