Calculating stock on hand in Zoho analytics

PHOTO EMBED

Tue Feb 17 2026 10:50:58 GMT+0000 (Coordinated Universal Time)

Saved by @RehmatAli2024 

SELECT
		 "Import items"."SKU" as "Imported SKU",
		 "Items"."Item ID" as "ID",
		 "Items"."Item Name" as "Item Name",
		 "Items"."Status" as "Status",
		 "Test"."Stock on Hand" as "Stock on Hand"
FROM  "Import items"
LEFT JOIN "Items" ON "Items"."SKU"  = "Import items"."SKU" 
LEFT JOIN "Test" ON "Test"."Product ID"  = "Items"."Item ID"
content_copyCOPY