The logic to my selection is:

If the item_id  is stockable use Last sales Date if the item is nonstock then use > OH Qty for selection.  First of all is this possible? and second when i run this selection it gives me the whole database all items i only want items that fall in those requirements, i tried doing a else statement to no avail.


if({p21_item_location_view.stockable} = "Y" and {p21_item_location_view.last_sale_date} < Date (2008, 01 ,07 )) or
({p21_item_location_view.stockable} = "N"  and {p21_item_location_view.qty_on_hand} > 0 and
{p21_item_location_view.delete_flag} = "N")

Should use or or else maybe there is a better way to write this im not sure i am still a novice to writing formulas.