7 Replies Latest reply: Aug 4, 2010 6:57 AM by Christo Roder RSS

    Set analysis - Ignore selection

      Good day everyone.

      I have the following fields: WarehouseCode, QtySold, QtyOnHand, ItemCode.

      I have the following expression: (sum({<ItemCode={"F*"} , WarehouseCode={"ZA01"}>} (QtyOnHand))) / (sum({<ItemCode={"F*"}>} (QtySold))/130)

      What I want to do is sum all the QtyOnHand for a specifice warehouse (ZA01) and divide it by the QtySold for ALL warehouses (Not only Warehouse ZA01). Note that I only need this for ItemCodes starting with an "F".

      Please help me in adjusting my Set analysis in order to accomplish this.

      Thanks