Originally posted by: mikedb

Order(s)
--Header
--Line Item(s)
--Line Number:Field
--Item Code:Field
--Amount:Field
--Item Type:Field

Using the above "Tree", I want to SUM(Amount:Field:Line Item:Order) but only for a particular "Item Type". So there would be a 'where' clause on the SUM(). At the Order/Header level, how do I do this?

#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

does this work ?

SUM(EXTRACT (Amount:Field:Line Item: Order, Item Type = "X"))
#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

Originally posted by: mikedb

I do not believe you can do a SUM() on an EXTRACT() object. You will get a build error.
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange

Originally posted by: SystemAdmin

You can put an EXTRACT inside a SUM -
Can you post the rule that you are using? What's the build error that you get? What version of WTX are you using?
#IBMSterlingTransformationExtender
#DataExchange
#IBM-Websphere-Transformation-Extender

Originally posted by: SystemAdmin

I'm not clear what the domain is across which you want to sum the amount. If it is for all orders, then you need to sum above the Order level. If you wish to sum the items for each order, then the SUM function should be at the Order/Header level. Olly's map rule should work for the summing at the order level.

Jim Divoky
EC Solutions, Inc.
330-606-6826
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender
#DataExchange