I have a report where in the linking i have set the po orderqty =count table
My table is 1-24 to allow for items that i have need up to 24 labels. This works fine except when my order unit is greater then 1. For example

x item orderqty= 2 order unit box-12 conversion 12
this would when received for my po would = orderqty*conversion or 2*12=24
I would show 24 items in my inventory when received.
this relates to the report because the orderqty= table (in linking)-so since the order qty is 2 my report prints out 2 labels
I have been trying to write a statement that looks something like this (but I keep getting errors) remember I have a join setting poline.orderqty ={count.table}
I have several types of order units that i will have to add into the formula but for now just trying to get 1 to work.

if {POLINE.ORDERUNIT}= "box-12" then
{POLINE.ORDERQTY}*{POLINE.CONVERSION}else
{POLINE.ORDERQTY}={count.table}

here is my current sql
max40385
SELECT "INVENTORY"."ITEMNUM", "INVENTORY"."ORDERUNIT", "INVENTORY"."BINNUM",
"INVENTORY"."MODELNUM", "ITEM"."DESCRIPTION", "POLINE"."ITEMNUM",
"POLINE"."ENTERDATE", "POLINE"."PONUM", "POLINE"."ORDERUNIT", "POLINE"."ORDERQTY"
FROM "MAXIMO"."INVENTORY" "INVENTORY", "MAXIMO"."POLINE" "POLINE",
"MAXIMO"."ITEM" "ITEM"
WHERE ("INVENTORY"."ITEMNUM"="POLINE"."ITEMNUM") AND ("POLINE"."ITEMNUM"="ITEM"."ITEMNUM") AND "POLINE"."PONUM"='24142' AND "POLINE"."ITEMNUM"='1201020021N'
EXTERNAL JOIN POLINE.ORDERQTY>=
{?C:\Documents and Settings\kpowell\My Documents\test table.xls: Sheet1_.Column1}


C:\Documents and Settings\kpowell\My Documents\test table.xls
SELECT `Sheet1_`.`Column1`
FROM `Sheet1$` `Sheet1_`
WHERE `Sheet1_`.`Column1`<={?max40385: POLINE.ORDERQTY}